4.1 SELECT 语句
4.2 检索单个列
select title from music;
4.3 检索多个列
select title,singer from music;
4.3 检索所有列
select * from music;
4.5 检索不同的行
select vend_id from products;
select distinct vend_id from products;
4.6 限制结果
select prod_name from products limit 5;
返回第一行或者前几行。
select prod_name from products limit 5,5;
从第五行开始返回5行。
4.7 使用完全限定的表名
select products.prod_id from products;
select products.prod_id from mysqllearn.products;
数据库名字为:mysqllearn