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

删除

🚩修改(实际开发中最多)

image

image

posted @ 2022-10-12 19:08  java同学!  阅读(16)  评论(0)    收藏  举报