I am tring import data from sql file using command line like this: mysys-12: mysql -u root -p my_db_t < my_db_t_2022_10_12.sql but I got: mysql: [ERROR] unknown variable 'sql-mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTIO How can I import data? Should I add any params?
How to export the data from mysql as xlsx, mysql workbranch only support export as CSV as i see in workbranch. I wan to have some programme which can directly get an mysql stored procedures result as .XLSX format file.…
How do I calculate the negative difference between each row and return as a total sum? For example (col "fictional difference" is only for better understanding): id value fictional difference 0 63 0 -> ignrore 1 61 -2 2 55…
And the output that I am looking for is against every hhid, I want to calculate the average of the last 3 months of ttlasset and ttlimcome and the date(frdate) should be the max date. So for every hhid, on…
I want to make a crawler that will just keep going infinitely until a page has no links. Every time it crawls a page it returns the html of the webpage so I can parse it and get the title,…
Is it possible to create a table in SQL, in which 1 column gives the consecutive Sundays. The other column has the upcoming 7 sundays corresponding to each sunday on column1. Expected output below: Any help is extremely appreciated.
I have a users table like this: I would like to display a query, where every user is listed twice with different text (created_at / updated_at) and the date. The merged query should be ordered by date (created_at and updated_at).…
I'm using Laravel 8. I would like to have a query, where all items from the users table are listed twice, one with created_at column, and second with updated_at column. The result of this array should be in an ascending…
i just started my journey with SQL, and made some tables of Cyclists, and Cycling Teams. Cyclist's table contains columns: ID, Name, Team (which is foreign key of TEAMS ID) Team's table contains columns: ID, Name, Number of Cyclists I…
I'm having a lot of difficulty writing an SQL query. I need to compute the difference between consecutive rows for 4 different regions across different years, then subsequently display only the top 3 regions with the highest count of negative…