create table with two timestamp values (1 reply)
(MySQL.com) I'm using MySQL 5 and I want to create a table with, among other things, two timestamp columns, one called DATE_MOD whose default value is the current date and time when the record is added and gets changed whenever the record is modified (ON UPDATE
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-01 15:36:41
