> 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?
Then you need to go back to reading the manual again. UPDATE
statements do not allow for ORDER BY clauses.
/ Carsten
---------------------------------------------------------------------
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
