一段时间不写就忘记了,写个博客记录哈
-- 建表
CREATE TABLE
IF NOT EXISTS USER (
id VARCHAR (125) NOT NULL COMMENT 'id',
user_name VARCHAR (64) NOT NULL COMMENT '用户名',
real_name VARCHAR (64) COMMENT '姓名',
idcard VARCHAR (64) COMMENT '身份证',
sex CHAR COMMENT '性别',
telephone VARCHAR (64) COMMENT '电话号码',
address VARCHAR (255) COMMENT '家庭住址',
email VARCHAR (64) COMMENT '邮箱'
) COMMENT = '用户表',
ENGINE = INNODB,
auto_increment = 1000,
charset = utf8;
-- 增加主键约束
ALTER TABLE `user` ADD PRIMARY KEY(id);
ALTER TABLE `user` DROP PRIMARY KEY ,ADD PRIMARY KEY(idcard);
-- 添加索引
ALTER table `user` ADD INDEX (idcard);
-- 增加字段
ALTER TABLE `user` add password VARCHAR(64) COMMENT '密码';
-- 删除字段
ALTER TABLE `user` DROP password;
-- 插入数据
INSERT INTO `base`.`user` (
`id`,
`user_name`,
`real_name`,
`idcard`,
`sex`,
`telephone`,
`address`,
`email`
)
VALUES
(
REPLACE(UUID(), '-',''),
'lala',
'唐一年',
'620301198807191534',
1,
'15095398745',
'甘肃省兰州市',
'97878785@qq.com'
);