From: Johan De Meersman Date: February 22 2012 6:48pm Subject: Re: Removing Data Duplicacy List-Archive: http://lists.mysql.com/mysql/226841 Message-Id: <526e23d0-155f-4842-bde0-81108c5edabd@zimbra> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Johnny Withers" > > 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