Hello.
UPDATE in MySQL supports only row_count. See: http://dev.mysql.com/doc/mysql/en/update.html The same you could get from source file "sql/sql_yacc.yy". David Legault wrote: > Hello, > > I'm using the MySQL C API and I got the following error for this query: > > UPDATE tracks SET track_state='-2', track_cost='1.500000' WHERE > track_flynum='10' AND track_testcase='45' ORDER BY track_step DESC LIMIT > 0,1 > > SQL Error 1064 : 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 '1' at line 1 > > If I put LIMIT 1 instead of LIMIT 0,1 I get the correct result. > > This seems to be a weird problem and according to the documentation, > should be equivalent, but it seems not. > > Running on Win2k, MySQL 4.1.11, mysqld-nt.exe > > Thanks > > David > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
