From: W. D.
Date: October 17 2012 6:23am
Subject: Possible to copy the key field to another on INSERT?
List-Archive: http://lists.mysql.com/mysql/228431
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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!=99 ->=
 http://www.US-Webmasters.com/best-start-page/
$8.77 Domain Names -> http://domains.us-webmasters.com/