SQL syntax in QUICK

More
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?

Please Log in to join the conversation.

More
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.

More
7 years 6 months ago #5645 by 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.

Cron Job Starts