CREATE TABLE result(
studentno INT(4) UNSIGNED COMMENT"学号" NOT NULL,
subjectno INT(4) UNSIGNED COMMENT"课程编号" NOT NULL,
examdate DATETIME DEFAULT ? COMMENT"考试日期" NOT NULL,
studentresult INT(4) UNSIGNED COMMENT"考试成绩" NOT NULL
);
CURRENT_TIMESTAMP OR NOW() 这两个关键词都是可以的
保存数据后是这样的
刷新下就好了