default就是你说的向该表添加数据的时候,不需给该字段赋值。不过你的SQL不能这么写,应该指明哪些字段。
insert into article (writer,content,time) values('Jack','this is the content','2002-12-23 12:22:33');得到系统时间用MYSQL的now()函数即可,如:
insert into article (writer,content,time) values('Jack','this is the content',now());
insert into article (writer,content,time) values('Jack','this is the content','2002-12-23 12:22:33');得到系统时间用MYSQL的now()函数即可,如:
insert into article (writer,content,time) values('Jack','this is the content',now());
( writer varchar(8),
subject varchar(20) default 'null',
content varchar(200)
time datetime,
);