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
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.50' 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
Note to self, check variables for typos before posting
to list!
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm trying to paginate my record results. Running
into a sql syntax error that is boggling my limited
brain cells.
The print out of my statement as it is parsed:
This is before the error occurs, the first 15 records
return fine:
WHERE VendorJobs.Industry IN ('3') AND
VendorJobs.JobTitle LIKE '%%
Hello Serge,
Serge E. Yakubovich wrote:
>>Description:
First of all I want to thank you for your excelent bug report and apologize for
delayed responce.
>The same test script I've submitted today to [EMAIL PROTECTED],
> which demonstrates improper(?) behaviour of UPDATE statement on
> 4.
>Description:
The same test script I've submitted today to [EMAIL PROTECTED],
which demonstrates improper(?) behaviour of UPDATE statement on
4.0.12 server under FreeBSD, on 4.0.15 server under Alt Linux causes
segmentation fault.
Below is messages from /var/log/mysql/info:
-
