----- Original Message ----- > From: "Johnny Withers" <joh...@pixelated.net> > > I'm not sure, It seems to me the proper way to do would be to insert > into table1, get the insert ID, then insert into table2 using that ID, > this is pretty standard stuff. > > Not sure why, in this case, he cannot do that.
last_insert_id() only works on tables with an auto_increment column, which was specified is not there and cannot be added. I still favour the testicular remediation path. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
