desc 查询表结构
desc table_name;

从表中查询某字段大于9的数据并按字段降序(desc)排序(默认升序)
select * from table_name where name>9 order by name desc;

查询条件 | 符号或关键字 | |
比较 | =(等于)、<(小于)、<=(小于等于)、>(大于)、>=(大于等于)、!=(不等于)、<>(不等于)、!>(不大于)、!<(不小于) | |
指定范围 | BETWEEN AND 、NOT BETWEEN AND | |
指定集合 | IN、 NOT IN | |
匹配字符 | LIKE 、NOT LIKE | |
多个查询条件 | AND(&&)、 OR(||) |
where条件表达式查询指定记录
select name1,name2,name3··· from table_name where name=*;

查询指定范围
select * from table_name where name between a and b;

匹配首字查询
select * from table_name where name like "*%";

or like 组合匹配查询
select * from table—_name where name1>* or name like "*%";

and or组合查询(and优先级更高)
mysql> select * from table_name where name1 in(num,num,num·····) and name2>num or name3
like "*%";

限制查询数量
select * from table_name limit n,m;
