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
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