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
I see the definition of update in the online manual... This is the link:
http://www.mysql.com/doc/U/P/UPDATE.html
and this is what is written:
From MySQL manual ONLINE ***
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001 11:05 AM
To: Carsten H. Pedersen; [EMAIL PROTECTED]
Subject: RE: UPDATE query with ORDER BY and LIMIT
I see the definition of update in the online manual... This is the link:
http://www.mysql.com/doc/U/P/UPDATE.html
and this is what