Alex Rivera | Logout

Alter table add new field "ON UPDATE CURRENT_TIMESTAMP"

Asked 2012-06-13T10:57:35.923
14

This is my table:

CREATE TABLE `megssage`(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) DEFAULT NULL,
  `time_create` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

I would like to add new column as time_updated with default value "ON UPDATE CURRENT_TIMESTAMP".

I tried this:

ALTER TABLE `megssage` 
   CHANGE `time_updated` `time_updated` TIMESTAMP NULL DEFAULT  ON UPDATE CURRENT_TIMESTAMP

But I am getting an error. Can someone help me?

Edit
Report

1 Answer

11

Try

ALTER TABLE `megssage` 
    CHANGE COLUMN `time_updated` `time_updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ;
answered 2012-11-15T14:29:38.610

Your Answer