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/


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql