Mysql select query statement, mysqlselect statement

Mysql select query statement, mysqlselect statement

1. Simple Query

Mysql> select * from students; + -------------- + ---------- + ------ + | id | sname | sex | tid | + ------------ + ---------- + ------ + | 0000000001 | orna | male | NULL | 0000000002 | luscy | female | NULL | 0000000003 | wangwu | male | NULL | 0000000020 | zhangsan | male | NULL | + ------------ + -------- + ------ + 4 rows in set (0.00 sec) mysql> select id, ifnull (sname, 'None') name from students; + ------------ + ---------- + | id | name | + ------------ + ---------- + | 0000000001 | orna | 0000000002 | luscy | 0000000003 | wangwu | 0000000020 | zhangsan | + ------------ + ---------- + 4 rows in set (0.00 sec)

Mysql> select * from students where sname like 'o % ';
+ ------------ + ------- + ------ +
| Id | sname | sex | tid |
+ ------------ + ------- + ------ +
| 0000000001 | orna | male | NULL |
+ ------------ + ------- + ------ +
1 row in set (0.00 sec)

2. Sorting

Mysql> select * from students order by sname desc; + ------------ + ---------- + ------ + | id | sname | sex | tid | + ------------ + ---------- + ------ + | 0000000020 | zhangsan | male | NULL | 0000000003 | wangwu | male | NULL | 0000000001 | orna | male | NULL | 0000000002 | luscy | female | NULL | + ------------ + -------- + ------ + 4 rows in set (0.00 sec) mysql> select * from students order by sname desc limit 1; + ------------ + ---------- + ------ + | id | sname | sex | tid | + ------------ + ---------- + ------ + | 0000000020 | zhangsan | male | NULL | + ------------ + ---------- + ------ + 1 row in set (0.00 sec)