MySQL查询数据的语法
select column_name,column_name from table_name [where clause] [limit n] [offset m]
举例说明
- select * from table (查询 table 中所有数据)
select * from people
- select column_name,column_name (按列查询)
select name,job from people;
- offset 和 limit(offset 确定开始的位置,limit 确定查询多少条数据,两个参数的位置不能反)
select * from people limit 2 offset 3;
- 通过 where 添加筛选条件(可以添加多个 and 或者 or )
select * from people where id>2;
select * from people where id>2 and age<20;
- 模糊匹配(用 like 匹配 age 的十位数是 2 的)
select * from people where age like “2%”;