Currently I'm studying and I received task to write query (join 4 tables: people, goods, orders and order details). So main table Order_details has two columns: Order_id and Good_id, in order to make possible to have many goods in one…
I am currently working on a project that has 2 very large sql tables Users and UserDocuments having around million and 2-3 millions records respectively. I have a query that will return the count of all the documents that each…
I have a table like this userId story novel 1 a b 1 a b 1 a c 1 b c 1 b c 2 x x 2 x y 2 y y 3 m n 4 NULL NULL How…
Indexes table Keyname Type Unique Packed Column Cardinality Collation Null Comment PRIMARY BTREE Yes No ID 7 A No AD_ID BTREE Yes No AD_ID USER_ID 1 2 A A No Yes USER_ID BTREE No No USER_ID 2 A Yes How…
I have a huge 23 GB CSV file I am trying to load, and I've found that instead of converting it to insert statements which takes a while, It's possible to directly load to the DB. So I tried the…
basically I'm making a page where the information from mySQL database will be displayed. I have a column named topics in the database where the string (VARCHAR) goes like this: Marketing, Business, Law, Medicine, ... I'm trying to break up…
Why must I state the table I'm referring to TWICE when using a join on a query? select table1.name from table1 inner join table2 on etc ...
I have a table in mysql called trans with the following structure: trans ( id number date date amount number ) The date is stored in the following format: 2021-09-21 I am trying to make a selection out of this…
The below query is taking time to execute. does this have any rewrite possibilities? Query; SELECT t_product.a_productid, t_product.a_mpactive, t_product.a_active, trim( substring_index(a_reference, '_',-1)) as a_reference, t_product.a_shopid, t_productlang.a_name, t_deactivatedproduct.a_reason FROM t_deactivatedproduct inner join ( SELECT max(a_deactivatedproductid) as a_deactivatedproductid FROM t_deactivatedproduct GROUP by…
pip install mysqlclient Collecting mysqlclient Using cached mysqlclient-2.1.1.tar.gz (88 kB) Preparing metadata (setup.py) ... error error: subprocess-exited-with-error × python setup.py egg_info did not run successfully. │ exit code: 1 ╰─> [16 lines of output] /bin/sh: 1: mysql_config: not found /bin/sh:…