數(shù)據(jù)庫(kù)創(chuàng)建表問(wèn)題
創(chuàng)建數(shù)據(jù)庫(kù)表報(bào)以下錯(cuò)誤
Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
3 回答
舉報(bào)
0/150
提交
取消
創(chuàng)建數(shù)據(jù)庫(kù)表報(bào)以下錯(cuò)誤
Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
舉報(bào)
2019-09-11
將數(shù)據(jù)庫(kù)的start_time和end_time那兩行改為:
start_time timestamp not null default '0000-00-00 00:00:00' comment '開始時(shí)間',
end_time timestamp not null default '0000-00-00 00:00:00' comment '結(jié)束時(shí)間',
create_time timestamp not null default current_timestamp comment '創(chuàng)建時(shí)間',
2019-08-08
我也遇到了 ,我的版本是5.5,怎么解決?? ?
2019-06-25
注意數(shù)據(jù)庫(kù)的版本問(wèn)題，如果你使用5.6 以前的版本，肯定有這個(gè)問(wèn)題