MySQL操作表

-- 删除表
DROP TABLE `test`.`stu_student`;
-- 创建表
CREATE TABLE `test`.`stu_student` (
  `id` VARCHAR(50) NOT NULL,
  `name` NVARCHAR(200) NULL,
  `address` NVARCHAR(200) NULL,
  PRIMARY KEY (`id`));

-- 查询
select * from stu_student;
-- 插入
insert into stu_student(id,name,address)values(uuid(),'张三','浙江');
insert into stu_student(id,name,address)values(uuid(),'李四','浙江');
insert into stu_student(id,name,address)values(uuid(),'王五','浙江');
-- 修改
update stu_student set address='江苏' where id='b64855df-32e2-11ea-85d8-68f72878211b';
-- 删除
delete from stu_student where id='b64855df-32e2-11ea-85d8-68f72878211b';