Topic-icon SQL syntax in QUICK

More
03 Mar 2018 14:52 #5645

The issue has been resolved, Please download and install the version again.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • vowswu
  • vowswu's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
02 Mar 2018 00:13 #5630

I use phpMyAdmin to check my systax, it can work. whether they are different from phpMyAdmin and vData?

Please Log in or Create an account to join the conversation.

  • vowswu
  • vowswu's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
01 Mar 2018 11:41 #5619

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 or Create an account to join the conversation.

Cron Job Starts