查询数据库的所有字段:
select * from table_name;
查询表中特定行的数据:
select column_name,column_name
from table_name;
查询-使返回唯一的值(合并值):
select distinct column_name
from table_name;
查询特定值:
select column_name
from table_name
where column_name=value;
select * from table_name;
select column_name,column_name
from table_name;
select distinct column_name
from table_name;
select column_name
from table_name
where column_name=value;