From: Michael Dykman Date: January 21 2011 4:49pm Subject: Re: CURRENT insert ID List-Archive: http://lists.mysql.com/mysql/224175 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable I think an ON INSERT TRIGGER would take care of this; can't think of any other way. =A0Using last_insert_id() in the argument list would likely yield you the previous value (which might not even related to your table. Having siad that.. =A0 odd requirement. =A0- michael dykman ps -- sorry for the duplicate Jerry, reply-to policy on this list is forever tripping me up. > > On Fri, Jan 21, 2011 at 11:41 AM, Jerry Schwartz wrote: >> Here it is in a nutshell: >> >> >> >> I have a field that needs to be set equal to the auto-increment ID as a = record is entered. I don=92t know how to do this without a subsequent UPDAT= E (which I can do with a trigger). Is there any way to avoid the cost of an= UPDATE? >> >> >> >> Here=92s a more concrete description of the problem: >> >> >> >> CREATE TABLE t ( >> >> id INT(11) AUTO-INCREMENT PRIMARY, >> >> xxx INT(11) >> >> ); >> >> >> >> When a record is added to table `t`, I need to set `xxx` to the value ge= nerated for `id`. (`xxx` might be changed later.) >> >> >> >> Is there anything clever I can do? >> >> >> >> Regards, >> >> >> >> Jerry Schwartz >> >> Global Information Incorporated >> >> 195 Farmington Ave. >> >> Farmington, CT 06032 >> >> >> >> 860.674.8796 / FAX: 860.674.8341 >> >> E-mail: =A0 jerry@stripped >> >> Web site: =A0 www.the-infoshop.com >> >> >> >> > > > > -- > =A0- michael dykman > =A0- mdykman@stripped > > =A0May the Source be with you. > --=20 =A0- michael dykman =A0- mdykman@stripped =A0May the Source be with you.