mysql常用命令
一、查询logs表中所有信息
1 | mysql> select * from logs; |
二、查询logs表中显示表中数
1 | mysql> select count(*) from logs; |
三、去重查询logs表中列name信息
1 | mysql> select distinct name from logs ; |
四、查询logs表中列uptime大于2017-11-24 17:16:41的信息
1 | mysql> select * from logs where uptime > '2017-11-24 17:16:41'; |
五、查询logs表中列uptime大于2017-11-24 17:16:41且小于2017-11-24 17:21:02的信息
1 | mysql> select * from logs where uptime between '2017-11-24 17:11:41' and '2017-11-24 17:21:02'; |
六、查询logs表中列name为guanggai并且caozuo为guang3或xiugai的信息
1 | mysql> select * from logs where (caozuo='guang3' or caozuo='xiugai') and name='guanggai'; |
七、logs表中以列uptime倒叙显示信息
1 | mysql> select * from logs order by uptime desc; |
八、查询logs表中name与uptime并以uptime正序显示
1 | mysql> select name,uptime from logs order by uptime asc; |
九、向logs表中插入name=haha,caozuo=xinzeng的数据
1 | mysql> insert into logs(name,caozuo) values('haha','xinzeng'); |
十、将logs表中列name=guang3更改为name=guang1且caozuo=xiugaii2
1 | mysql> update logs set name='guang1',caozuo='xiugaii2' where name='guang3'; |
十一、删除logs表中列name=guang3的数据
1 | mysql> delete from logs where name='guang3'; |
十二、删除logs表
1 | mysql> delete from logs; |
十三、查询test表前2行
1 | mysql> select * from test limit 2; |
十四、查询test表第二条至第三条数据
1 | mysql> select * from test limit 1,2; |
十五、查询test表name中第4个字母为n的数据
1 | mysql> select * from test where name like "%%%n%”; |
十六、查询test表name中类似x*ap的数据
1 | mysql> select * from test where name like 'x_ap'; |
十七、查询pet表包含正好5个字符的名字
1 | mysql> SELECT * FROM pet WHERE name LIKE "_____"; |
十八、查询test表name中以ig结尾的数据
1 | mysql> select * from test where name regexp "ig$”; |
1 | 如 SELECT * FROM [user] WHERE u_name LIKE ‘%三%’ |