我需要编写将列更新为CURRENT_TIMESTAMP()的BEFORE UPDATE触发器,但我做不到这一点。已尝试:CREATE FOR EACH ROW BEGIN
UPDATE csi SET tsu = CURRENT_TIMESTAMP WHERE csi_code = OLD.csi_code
int auto_increment, createtimestamp timestamp not null, PRIMARY KEY (rId));
它为createtimestamp创建一个默认模式为CURRENT_TIMESTAMPON UPDATE CURRENT_TIMESTAMP的表。没有默认设置的预期行为。但它被设置为默认值:CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP。为什