别都顾着JF啊,帮我解决一下问题
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 (外键列)