ON UPDATE CURRENT_TIMESTAMP -- 更新数据时自动同步时间
CREATE TABLE your_table
(
id INT AUTO_INCREMENT PRIMARY KEY,
data VARCHAR(255),
update_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
ON UPDATE CURRENT_TIMESTAMP -- 更新数据时自动同步时间
CREATE TABLE your_table
(
id INT AUTO_INCREMENT PRIMARY KEY,
data VARCHAR(255),
update_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);