4.Mysql 数据查找
精确查找 select distinct xx from [table_name] (去除重复数据);
查找结果升(降)序排列 select xx from [table_name] order by [column_name] asc(升序 默认) / desc (降序);
limit 语句 截取数据显示 select xx from [table_name] [where语句] [order by语句] limit [offset] rowcount;
select in 语法 select XX from [table_name] where [column_name] in (value1 ,value2……);
列名 in(value1,value2……) 等于 列名=values1 or 列名=value2
between 用法 select XX from [table_name] where [column_name] [not] between value1 and value2;
Happy New Year !