I have a (perl) script which inserts new entries into a mysql table. The table is indexed using an auto_increment column, so my inserts look like
insert into sometable columns (ID, other columns....) values (null, other values....)
I need to get the IDs of the newly created columns, to use elsewhere in the script. Is there a way to do this?
Thanks
Dave! [sig][/sig]
insert into sometable columns (ID, other columns....) values (null, other values....)
I need to get the IDs of the newly created columns, to use elsewhere in the script. Is there a way to do this?
Thanks
Dave! [sig][/sig]