SQL syntax in QUICK
- Daniel
- Offline
- Administrator
-
03 Mar 2018 14:52 #5645
by Daniel
Thanks
Daniel
Replied by Daniel on topic SQL syntax in QUICK
The issue has been resolved, Please download and install the version again.
Thanks
Daniel
Please Log in to join the conversation.
- vowswu
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 6
02 Mar 2018 00:13 #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.
- vowswu
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 6
01 Mar 2018 11:41 #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.