Value of a referenced field 2006-06-29 - By Aleksandar Bradaric
Back
Hello Andreas,
You could try with this:
> insert into table1 (authorid, lastname, firstname)
> values (nextval('s_authors'), 'Meyers', 'Scott');
INSERT INTO table1(authorid, lastname, firstname)
VALUES (null, 'Meyers', 'Scott');
> insert into table2 (authorid, title, subtitle)
> values (currval('s_authors'), 'Effektiv C++ Programmieren',
> '50 Wege zur Verbesserung Ihrer Programme und Entwuerfe');
INSERT INTO table2 (authorid, title, subtitle)
VALUES (last_insert_id(), 'Effektiv C++ Programmieren',
'50 Wege zur Verbesserung Ihrer Programme und Entwuerfe');
Best regards,
Aleksandar
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
