查询数据表的全部内容
mysql> show tables;#查看当前数据库下的全部表+--------------------+| Tables_in_ceshi_ku |+--------------------+| biao || ceshi_biao |+--------------------+2 rows in set (0.00 sec)mysql> select * from biao;#查看该表全部的内容。*代表通配符。在这里是代表全部的列+------+-----------+--------+----------+--------+| id | name | gender | gongsi | gongzi |+------+-----------+--------+----------+--------+| 1 | ma yun | n | tao bao | 6000.5 || 2 | xiao hong | v | xin lang | 5000.7 || 3 | xiao ming | n | bai du | 3000.4 || 4 | li si | n | sou hu | 9000.2 || 5 | lao wang | NULL | wang yi | 1000.5 || 6 | xiao li | NULL | ku gou | 700.1 |+------+-----------+--------+----------+--------+6 rows in set (0.00 sec)
查询数据表的全部列、部分行
mysql> select * from biao where id>4;#查询全部列,部分行,即id大于4的行+------+----------+--------+---------+--------+| id | name | gender | gongsi | gongzi |+------+----------+--------+---------+--------+| 5 | lao wang | NULL | wang yi | 1000.5 || 6 | xiao li | NULL | ku gou | 700.1 |+------+----------+--------+---------+--------+2 rows in set (0.02 sec)
查询数据表的部分列、全部行
mysql> select name,gongzi from biao;#查询部分列,即"name"和"gongzi"列,之间用","隔开。选择全部行+-----------+--------+| name | gongzi |+-----------+--------+| ma yun | 6000.5 || xiao hong | 5000.7 || xiao ming | 3000.4 || li si | 9000.2 || lao wang | 1000.5 || xiao li | 700.1 |+-----------+--------+6 rows in set (0.02 sec)
查询数据表的部分列、部分行
mysql> select name from biao where gongzi>3000;#选择部分列,即"name"列。也能够多个列。然后选择工资>3000的行+-----------+| name |+-----------+| ma yun || xiao hong || xiao ming || li si |+-----------+4 rows in set (0.00 sec)