At 00:40 16/08/99 , Jeremy Fitzhardinge wrote:
Hi all,
I'm using Zope with MySQL to do fairly normal database type things. A number of my tables make use of the AUTO_INCREMENT feature to generate unique primary keys, which I use internally for things like user IDs. The problem is that after inserting a user, I want to use LAST_INSERT_ID() to get it back. This is what I tried:
insert users (name, email, type) values('foo', 'bar@biff.org', 'normal'); select user_id from users where user_id = LAST_INSERT_ID()
This always complains about a syntax error at the ';'.
Use <!--#var sql-delimiter--> instead: insert users (name, email, type) values('foo', 'bar@biff.org', 'normal') <!--#var sql-delimiter--> select user_id from users where user_id = LAST_INSERT_ID() -- Martijn Pieters, Web Developer | Antraciet http://www.antraciet.nl | Tel: +31-35-7502100 Fax: +31-35-7502111 | mailto:mj@antraciet.nl http://www.antraciet.nl/~mj | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 ------------------------------------------