spidertime datetime NOT NULL default CURRENT_TIMESTAMP REFERENCES Customers on update CASCADE set spidertime=CURRENT_TIMESTAMP
建表时的一段 报SET 附近语法错误
急啊
------解决方案--------------------
create table test(spidertime datetime NOT NULL default CURRENT_TIMESTAMP REFERENCES Customers(a) on update CASCADE )
------解决方案--------------------
spidertime datetime NOT NULL default CURRENT_TIMESTAMP REFERENCES Customers on update CASCADE set spidertime=CURRENT_TIMESTAMP
---------------------
set spidertime=CURRENT_TIMESTAMP
这句就不要了吧,都写级联更新了 on update cascade
references customers 后面要指定哪列
references customers (外键列)