| List: | General Discussion | « Previous MessageNext Message » | |
| From: | W. D. | Date: | October 17 2012 6:23am |
| Subject: | Possible to copy the key field to another on INSERT? | ||
| View as plain text | |||
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/
| Thread | ||
|---|---|---|
| • Possible to copy the key field to another on INSERT? | W. D. | 17 Oct |
| • Re: Possible to copy the key field to another on INSERT? | Dehua Yang | 17 Oct |
| • Re: Possible to copy the key field to another on INSERT? | Shawn Green | 17 Oct |
| • Re: Possible to copy the key field to another on INSERT? | Dehua Yang | 17 Oct |
| • Re: Possible to copy the key field to another on INSERT? | Claudio Nanni | 17 Oct |
| • Re: Possible to copy the key field to another on INSERT? | W. D. | 17 Oct |
| • Re: Possible to copy the key field to another on INSERT? | W. D. | 18 Oct |
