5.20ZY

1.mysql

-- 查询所有用户
select user ,host from user;
-- 增加用户
-- create user 用户名 identified by 密码
create user xinjing@'%' identified by '123';
 -- 删除用户
 drop user xinjing@'%';
  -- 用户授权
    grant all privileges on student.* to 'xinjing'@'%'identified by '123' with grant option;
    -- 查看用户授权情况
    show grants for xinjing@'%';
    -- 回收用户的授权
    revoke all privileges on student.* from 'xinjing'@'%';
-- union查询
    use student;
  create table temp1(
     uid int primary key auto_increment,
     uname varchar(20) not null
     )
     insert into temp1(uname) values ('as'),('we'),('zx');
     select * from temp1;
     create table temp2(
       eid int primary key auto_increment,
         age int not null
         )
    select * from temp2;
    
    insert into temp2(age) values(11),(45),(25);    
    select * from temp1 union select * from temp2;
    
    select * from score;
    
    -- 分组展示
    select sid,group_concat(cid),group_concat(cj order by cj desc separator'') from score group by sid
    
    -- 字符串函数
    select lower('ASAasd');