List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:February 22 2012 6:48pm
Subject:Re: Removing Data Duplicacy
View as plain text  
----- Original Message -----
> From: "Johnny Withers" <johnny@stripped>
> 
> 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
Thread
Removing Data DuplicacyAdarsh Sharma22 Feb
  • Re: Removing Data DuplicacyJohan De Meersman22 Feb
    • Re: Removing Data DuplicacyArthur Fuller22 Feb
      • Re: Removing Data DuplicacyJohnny Withers22 Feb
      • Re: Removing Data DuplicacyAdarsh Sharma23 Feb
        • Re: Removing Data DuplicacyJohan De Meersman23 Feb
Re: Removing Data DuplicacyJohnny Withers22 Feb
  • Re: Removing Data DuplicacyJohan De Meersman22 Feb