MYSQL - Devinwon/article GitHub Wiki

select * from tablename limit 1 //限制返回数目，超过则返回全部 select * from tablename limit 1 offset 2 //分页，下一条语句功能一样 select * from tablename limit 1 ， 2

select* form tablename where field like binary '%string%'//模糊搜索，精确条件放在前面

select * from tablename inner join anothertable on publicfield where tablename.condition inner join(二者都有才返回) right join(返回右) left join （返回左）