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