I am working on a mini banking app. I want to query the database in which all the transactions made so far are stored with three query parameters which are, user account,startDate and endDate. the database has a column for…
I've been trying to solve this problem for 2 days and have basically gone through everything I could find here on stackoverflow, maybe I'm missing something since I've been staring at it for so long. I have a nodejs file…
Prevously I asked a question here, but after re-read it, I realised it's more complicated so I'm asking a new question here. I have following table: how to sort the table based on collecting the name from the same favorite,…
im trying to display all the items sold and not sold within a period of time im unable to display on the join tables all the items that have previously arrived if there were none sold. select arrivals.description, COALESCE(sum(orders.quantity ),…
i want to select row by the highest votecount from a table, but if the userid is repeted i want the just the row with the highest votecount. eg: userId votecount 2 2 2 12 1 20 my result is…
I am building a leaderboard which is built by joining two different databases, the most important is the wallet column which is what I'll use to rank the players. I need to add a column ranked from the player with…
I have a JSON column "jobs" that looks like this: [ { "id": "1", "done": "100", "target": "100", "startDate": "123123132", "lastAction": "123123132", "status": "0" }, { "id": "2", "done": "10", "target": "20", "startDate": "2312321", "lastAction": "2312321", "status": "1" } ]…
data There're multiple tables which format is dm_ym_file_2022XXXX(date). The start date is 20220720 and the end date is 20221220 dm_ym_file_20220720 dm_ym_file_20220721 …… dm_ym_file_20221220 dm_ym_file_rules stores all names.The dm_ym_file_rules as belows: ID start_date end_date table_names 36 2022-07-20 2022-07-20 dm_ym_file_share_20220720 37 2022-07-21…
I am try to import csv file into mysql in command prompt without workbench. But it shows error like ERROR. what is the best way to import csv file without workbench. what is best way to resolve the error.
I’m using MySQL to make a table: CREATE TABLE school.student( Std_id INT NOT NULL AUTO_INCREMENT, Std_name CHAR(40) NOT NULL, Std_Birth DATE, Std_Group CHAR(2) check(Std_Group in ('G1', 'G2','G3','G4')) ); And I’m trying to make the auto increment start from 1000 and…