MySQL 带默认值的表插入默认值数据values(default,default) 或values(NULL,NULL);
CREATE TABLE test(
id SERIAL PRIMARY KEY,
`datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
);
INSERT INTO test values(default,default);
INSERT INTO test values(NULL,NULL);
SELECT * FROM test;
还没有评论,来说两句吧...