正常查询:
- mysql> select shell from tarena.user where shell in ("/bin/bash","/sbin/nologin") ;
- +---------------+
- | shell |
- +---------------+
- | /bin/bash |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /sbin/nologin |
- | /bin/bash |
- | /sbin/nologin |
- +---------------+
- 22 rows in set (0.00 sec)
distinct
mysql> select distinct shell from tarena.user where shell in ("/bin/bash","/sbin/nologin") ;
- +---------------+
- | shell |
- +---------------+
- | /bin/bash |
- | /sbin/nologin |
- +---------------+
- 2 rows in set (0.01 sec)
concat合并 as别名
mysql> select concat(name , "-" , uid) as 用户信息 from tarena.user where uid <= 5;