Mysql – Why must I state the table I'm referring to TWICE when using a join?
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 ...
Get daily average by column even though there are empty dates in MYSQL
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…
Mysql – how to optimize the slow query?
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…
Please help me to fix the error – mysqlclient
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:…
cte table does not exist mysql
I am trying to calculate the number of users who have an active subscription on a particular day. I also want information related to the subscription plan they are on. I have a subscriptions table which includes the start date…
Mysql – Is it possible to replace not exists with join in this query?
I have this query SELECT * FROM table1 as t1 WHERE (t1.phone != "" OR t1.sms_phone != "") and t1.docType in (1,2,3) and not exists (select id from table2 where product_id=1 and doc_id=t1.id); And I want to replace the part…
Mysql – How can I fetch products with the highest price in SQL with LIMIT
I tried to fetch 50 products from a database with the highest price but if i set the LIMIT at 50 it's just fetching the first 50 products order by the price. This is not what i want. How can…
Mysql – Allocation values from one row to another in SQL
I have the following table: CREATE TABLE table_one( person varchar(55), date_value date, proj varchar(2), value int, time varchar(2 ); INSERT INTO table_one VALUES ('A1',2020-10-01'W',10,'T1') ('A1',2020-10-01'A',5,'T2') ('A1',2020-10-01'P',6,'T3') ('A1',2020-10-01'A',9,'T4') ('A1',2020-10-01'P',11,'T5') ('A1',2020-10-01'A',4,'T6') ('A1',2020-10-01'P',2,'T7') ('A1',2020-10-01'A',1,'T8') ('A1',2020-10-01'P',10,'T9') ('A1',2020-10-01'A',8,'T10') I want an SQL query which creates…
a query to check value in other table – Mysql
I have below tables DEMO fiddle In x_table, I have different records. I want to fetch all currencies from x_table where continent is Asia which is straight forward as below, SELECT currency from x_table where continent='Asia' and it should return…
Mysql – Get database column into rows with duplicate data
I've mysql database where data is column: +----+-------+--------+--+ | ID | refID | data | | +----+-------+--------+--+ | 1 | 1023 | aaaaaa | | | 2 | 1024 | bbbbbb | | | 3 | 1025 | cccccc |…