SQL syntax in QUICK

More
03 Mar 2018 14:52 #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.

  • vowswu
  • Topic Author
  • Offline
  • New Member
  • New Member
More
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
  • New Member
More
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?

Please Log in to join the conversation.

Cron Job Starts