I need to create an Access database from an existing mySQL database. I was able to import some of the tables using the ODBC connection but a few of the tables w
I found this picture in a document. It shows the queries running on a given SQL database. It looks similar to DBeaver software. However, I couldn't find a way t
I want to generate the below result and here is my query SET @count:=0; SELECT Workout.created_by, SUM(Workout.training_load) as TL, FB_User.name from FB_Worko
In my table named Follow, there is the information of those who are followed. For example, let's say my user id is 1: tableID | followerID | followedID ________
I have a table with columns like this Std_id Class Section 14 8 2 14 8 1 14 9 1 15 8 3 15 8 2 15
I have a mysql query that works perfectly without the HAVING clause, but when I use that clause I get an error and I think it has to do with the fact that I'm u
I have csv file which has data as in following format(data has converted from rrd to csv) ..... ...... <database> <!-- 2022-04-26 22:04:00 +0530 /
i have two mysql connection and i want to migrate specific database with php artisan migrate --database=databasename and when i ran command php artisan migrate
The following query is taking forever in MySQL 5.7.23, on a macOS 10.13.6 on 2018 Macbook Pro (A1990) with 50GB of free space: INSERT INTO `a_sg1lib` (`book_id`
I have created a new Spring Starter Project and I specified in application.properties the db settings: spring.jpa.hibernate.ddl-auto=update spring.datasource.dr
what i want to do is to get the number of pages for this writer be I have written a code and have a problem the code is: select concat(author_fname, ' ', author
I am very to the new MYSQL and creating a store procedure using dynamic query which is containing the steps as CREATE TEMPORARY TABLE(THE NAME OF THE TEMPORARY
I am trying to get a result for the query: SELECT product, exportcountry FROM is_exported_to CROSS JOIN is_produced_in WHERE product = cheese AND origin = 'Fran
I have a select option that the purpose is to filter the division of the user, in my current code the data will show if the user start selecting a list of data
When typing a query into MySQL Workbench, the autocomplete suggestion popup is so slow. After typing a couple letters of a column or table name, I have to pause
I'm trying to speed up a mysql query. The Listings table has several million rows. If I don't sort them later I get the result in 0.1 seconds but once I sort it
I am trying to write a query to get the last 4 weeks (Mon-Sun) of data. I want every week of data to be stored with an individual and shared table. every week d
I want to calculate total followers of a person from follow and unfollow table using SQl. Form of table are as follows Follow table: Unfollow table: My tries:
I have a small GUI application that is supposed to access a local MySQL database. It works fine from my IDE and jar file but once I use the jpackaging tool to t
Is there any way to migrate multiple columns data of table to only one column of other? I need to migrate the data of table 1 subject varchar(45) body