Lingrayy的博客

创建用户create user 'xjy'@'%' identified by '123456789';设置权限grant select on mydb.account to 'xjy'@'%';查看用户use mysql;select * from user;查看权限show grants for 'xjy'@'%';删除权限revoke select on mydb.account from 'xjy'@'%';2.分别使用第三方工具以及..

1 创建一张表，要求包含：主键约束，非空约束，唯一约束；然后插入数据测试3种约束的特点（截图展示结果）主键约束create table test(id int primary key ,name varchar(40) not null,address varchar(200) unique);insert into test(id,name,address) values (1,"秦羽","秦氏修仙家族");insert into test(id,name,address) val

//1、创建数据库 mydbCREATE DATABASE mydb;//2、创建表格booksCREATE TABLE books(b_id int(11),b_name varchar(50),authors varchar(100),price float,pubdate year,note varchar(100),num int(11));