From: Dehua Yang Date: October 17 2012 7:33am Subject: Re: Possible to copy the key field to another on INSERT? List-Archive: http://lists.mysql.com/mysql/228432 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf303f6d1e223de004cc3c48b4 --20cf303f6d1e223de004cc3c48b4 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable select LAST_INSERT_ID() ; Under high concurrency , it would return other threads value to you. On Wed, Oct 17, 2012 at 2:23 PM, W. D. wrote: > When creating a record, the first field (KeyField)... > > KeyField BIGINT UNSIGNED NOT NULL AUTO_INCREMENT > > ...is it possible to copy this auto-generated value into > another field when using the same INSERT that creates the record? > > Or would I have to use an UPDATE query using LAST_INSERT_ID() > immediately after the INSERT statement? > > Thanks for any ideas you have. > > Start Here to Find It Fast!=E2=84=A2 -> > http://www.US-Webmasters.com/best-start-page/ > $8.77 Domain Names -> http://domains.us-webmasters.com/ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > --=20 B.rgds / Whitepoplar (=E6=9D=A8=E5=BE=B7=E5=8D=8E=EF=BC=89 --20cf303f6d1e223de004cc3c48b4--