as far as i know, you can only have one auto_increment field. you'd have insert,
then grab the id and update that record, just like you've said. make sure that
you grab the last assigned id using a valid method. if it's a sign-up form, do
something like the following to make sure you are actua
TIMESTAMP does what you want, but if you for any reason wish to update records
(mass updates) at the mysql> prompt without updating the TIMESTAMP, you'd be out
of luck. For databases where I know that mass updates to data files will be
required, and I want to preserve the user's LAST_MODIFIED (TI