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
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