MYSQL基础

1、登陆 mysql -u root -p test
2、use staff_manage //使用数据库
3、show databases; //显示所有相关数据库
4、show tables; //显示数据库的所有表信息
5、show columns from admin; //展示admin表的具体信息
6、describe admin; //和5效果相同
7、select name from admin;
select distinct name from admin;
8、select name from admin limit 5; //限制结果数量
select name from admin limit 5,4; //分页使用一般从行6开始的4行
注意limit1,1检索出的是第二条记录而不是第一条 第一条是0
9、select name from admin order by name,age;//排序,可以多个条件排序 默认升序asc如果降序后面添加desc，desc只对应它前面那个列
10、查找最高最低值可以这样写 select price from product order by price desc limit 1;
11、select name from product where price between 10 and 100;
12、select name from product where price is null;
13、select name,price from product where (company_id=1000 or company_id=1003) and price>=100;
14、select name,price from product where company_id in(1002,1003) order by name;
15、not否定后面的条件select name,price from product where company_id not in(1002,1003) order by name; not支持对in between 还有exists进行取反
16、通配符%匹配任何字符出现任意次数： select name,price from product where name like '%anvil%';
17、通配符_匹配单个字符：
18、正则表达式：select name from product name REGEXP '.1000'; REGEXP后面是正则表达式内容
19、拼接： select Concat(name,'(',age,')') from product order by price;
20、mysql使用rtrim去掉右侧空格