Re: LIMIT error

2005-06-11 Thread Gleb Paharenko
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

Re: LIMIT error

2005-06-10 Thread Kristen G. Thorson
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