题解 | #检索所有列#
检索所有列
http://www.nowcoder.com/practice/cf0e3919ba8e4fa2ba19ea09df7fb756
Mysql检索列的基本语法为
基本语法为:
select col from table;
检索所有列有两种方法
# 方法1
select * from table;
# 方法2
select col1,col2,... from table;
题解
select cust_id, cust_name
from Customers;