Hi to all!
I have to use an UPDATE query with ORDER BY and LIMIT clauses.
This is the query:
UPDATE TBLTEST SET LOCKEDBY='test' WHERE FIELD1 LIKE 'test_' ORDER BY
INS_DATE LIMIT 1;
MySql tells me that I have an error in my SQL syntax near 'ORDER BY
INS_DATE' at line 1.
I use Mysql 3.23.30-gamma with MyIsam table format.
I have read the manual and the syntax, according to that, seems to be
correct... but... nothing is as it seems.... What is wrong?
Thank you to all for the help!
Denis
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
