Re: Override CURRENT_TIMESTAMP in trigger?

[Devart Team]

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/