Re: auto increment value in tables

2002-10-15 Thread Jim Lundeen
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

Re: Insert default Date

2002-10-15 Thread Jim Lundeen
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