mysql - 执行更新查询时更改 TIMESTAMP

Question

我尝试使用更新查询更新一些值，但在 reg_update 上创建此表时遇到问题：

CREATE TABLE Product (
  id INT(3) PRIMARY KEY,
  product VARCHAR(20) NOT NULL,
  reg_date TIMESTAMP,
  reg_update NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP 
);

我收到此错误：

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
that corresponds to your MariaDB server version for the right syntax to use 
near 'NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP 
)' at line 5

在这种情况下可以更新reg_update吗？

标签： mysqlddl

Answer 1

尝试这个

    CREATE TABLE Product (
      id INT(3) PRIMARY KEY,
      product VARCHAR(20) NOT NULL,
      reg_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
      reg_update TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP 
    );