I think you might be confusing UPDATE and SELECT syntax. As far as I
ever knew, you couldn't specify a limit offset in an update statement.
I don't see in mysql update docs where it indicates offset is allowed.
kgt
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
