MySQL 带默认值的表插入默认值数据values(default,default) 或values(NULL,NULL);

it2022-05-05  111

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;


最新回复(0)