mysql 条件 开头为Zz_mysql命令

一、查询表内容：

select * from `tablename`

select `nicheng` from `tablename`

select distinct `nicheng` from `tablename` 二、where查询：

select `id` from `tablename` where `id`>10 or (`id`<5)

三、in用法：

select * from `tablename` where `nicheng` in ('萧明', '秦城')

四、between用法：

select * from `tablename` where `id` between '003' and '009'

五、排序查询(ASC由小往大/DESC由大往小)：

select id , mima from `tablename`

where `nicheng`='萧明'

order by `id` ASC

limit 0 , 30

六、查询表中数据项数：

select count(*) from `tablename`

七、查询字段中内容数量：