SQL syntax in QUICK
7 years 6 months ago #5619
by vowswu
SQL syntax in QUICK was created by vowswu
I use OUICK to search data, and I got error message as below:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Key_name IN('PRIMARY', 'Unique')' at line 6
I use this syntax
SELECT *
FROM `tablename`
WHERE `fieldname`
BETWEEN '2018-01-01 00:00:00'
AND '2018-01-31 00:00:00'
Could you tell me how can I do?
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Key_name IN('PRIMARY', 'Unique')' at line 6
I use this syntax
SELECT *
FROM `tablename`
WHERE `fieldname`
BETWEEN '2018-01-01 00:00:00'
AND '2018-01-31 00:00:00'
Could you tell me how can I do?
Please Log in to join the conversation.
7 years 6 months ago #5630
by vowswu
Replied by vowswu on topic SQL syntax in QUICK
I use phpMyAdmin to check my systax, it can work. whether they are different from phpMyAdmin and vData?
Please Log in to join the conversation.