mysql - SQL stored precedure 2 insertstatements with 1 select needed for one insert -

mysql - SQL stored precedure 2 insertstatements with 1 select needed for one insert -

i got website database running on mysql community server (gpl) version 5.5.37

and want write stored precedure insert image in table 1 select id lastly post insert id in table 2.

i started google , ended this:

create procedure insertnewmedia( in insertlocatie varchar(255), in insertnaam varchar(150), in insertomschrijving longtext, in insertcategorieid int ) begin insert mediadb (idmediadb, locatie, naam, omschrijving) values (null, insertlocatie, insertnaam, insertomschrijving); select max(idmediadb) nieuwste mediadb; insert medialink (idmedialink, overmijshoots_idovermijshoots, mediadb_idmediadb) values (null, insertcategorieid, nieuwste); end

i know wrong code can't find awnser on need.

can help me?

i think looking last_insert_id():

delimiter // create procedure insertnewmedia( in insertlocatie varchar(255), in insertnaam varchar(150), in insertomschrijving longtext, in insertcategorieid int ) begin insert mediadb(idmediadb, locatie, naam, omschrijving) values (null, insertlocatie, insertnaam, insertomschrijving); insert medialink (idmedialink, overmijshoots_idovermijshoots, mediadb_idmediadb) values (null, insertcategorieid, last_insert_id()); end// delimiter ;

mysql sql-server stored-procedures