MySQL Forums
Forum List  »  Triggers

Re: Override CURRENT_TIMESTAMP in trigger?
Posted by: Devart Team
Date: May 24, 2012 01:04AM

I meant to disable this option directly in the table, e.g. -

CREATE TABLE table1(
  id INT(11) NOT NULL,
  ts TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id)
);

ALTER TABLE table1
  CHANGE COLUMN ts ts TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP

ALTER TABLE Syntax.

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Override CURRENT_TIMESTAMP in trigger?
1290
May 24, 2012 01:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.