mysql select desc_SQL语句之DQL数据查询语言（select、desc）

1.select查询语句

1.查询表中所有的数据

# 很危险，数据量过大，容易导致down机

mysql> select * from student;

# 先查询数据总量，然后决定是否可以查询所有数据

mysql> select count(*) from student;

+----------+

| count(*) |

+----------+

| 6 |

+----------+

1 row in set (0.01 sec)

2.查看指定列的数据

mysql> select user,host from mysql.user;

+--------+------------+

| user | host |

+--------+------------+

| root | % |

| root | 127.0.0.1 |

| lhd | 172.16.1.% |

| qiudao | 172.16.1.% |

| root | 172.16.1.% |

| root | ::1 |

| | db03 |

| root | db03 |

| | localhost |

| root | localhost |

+--------+------------+

10 rows in set (0.01 sec)

3.按条件查询

mysql> select name,gender f