Take a look at TRIGGERS C.
PS: I am curious to know why you would do that anyway 2012/10/17 W. D. <w...@us-webmasters.com> > 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!™ -> > 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 > > -- Claudio
