04表
创建
CREATE TABLE `user`(
id INT UNSIGNED, # 不加 unsigned 的默认有符号
`name` VARCHAR(200),
`password` VARCHAR(32),
`birthday` DATE,
`login_time` TIMESTAMP
NOT NULL DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP
-- 如果希望timestamp时间自动更新,就加入该语句
) CHARACTER SET utf8 COLLATE utf8_bin ENGINE INNODB || MYISAM;
INSERT INTO user VALUES(66, 'dd', 'dd', '2021'); # 插入新数据
INSERT INTO user(id, name) VALUES(1, '22'), (2, '44');
database04.sql