drop table IF EXISTS my_student;
create table my_student
(
id BIGINT UNSIGNED AUTO_INCREMENT COMMENT '数据ID',
birthday DATE NOT NULL DEFAULT (curdate()) COMMENT '生日',
version INT NOT NULL DEFAULT 0 COMMENT '版本号',
memo VARCHAR(255) NOT NULL DEFAULT '' COMMENT '其他说明',
create_by VARCHAR(32) NOT NULL DEFAULT 'System' COMMENT '创建人',
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_by VARCHAR(32) NOT NULL DEFAULT 'System' COMMENT '最后更新人',
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
PRIMARY KEY (id)
);
insert my_student(memo) value ('备注2');
update my_student set memo='修改1' where id = 1;
select * from my_student;