MySQL with Novell

[John Bell]

can run the following:

UPDATE NextId SET id=LAST_INSERT_ID(id+1);
SELECT LAST_INSERT_ID()

using NavICat on the Novell version of MySQL
(4.0.18b). However, when I run it from
TMyQuery, I get an syntax error. I can also
run the query (on one line) from the command
prompt. any ideas?

[Ikar]

Support of executing several queries for one time could be available only in MySQL 4.1.
You can use TMyScript to solve the problem.