Stuart, If the field is the only (or first) timestamp-type field in the table columns, then the record will automatically have the current date/time inserted when it is added. The only (or first) timestamp field will *also* be updated every time you update the record.
View the timestamp field in the manual for how to create it. Cheers Terry ----- Original Message ----- > I think this can be done, but tried a few times with > no success. I want a column in a table that sets a > timestamp. > Instead of passing a value from the form though is > there a way mySql would automagically stamp the > records as they are inserted ? > > and as a side note - would table type make any > difference. > > 4.0.20 - standard > > Thank you, > Stuart > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]