MySQL query data

Select  from test; +----+--------+| ID | Name   |+----+--------+|  1 | Apple  | |  2 | Banana | |  3 | Cherry | |  4 | Apple  | |  5 | Banana | |  6 | Cherry |+----+--------+

Mysql>Select* fromtest; # query all data mysql>SelectId,name fromtest; # query only data for id,name two fields MySQL>Select* fromTestwhereId=2; # only Query ID is2data for MySQL>Select* fromTestwhereId=1and name='Apple'; # query MySQL with and>Select* fromTestwhereId=1or name='Banana'; # query MySQL with or>Select* fromTestwhereIdinch(1,3); # UseinchQuery, which means that only the query ID is1And3data for MySQL>Select* fromTestwhereID between1and4; # Use Between...and ... Query, which indicates that only the query ID1-4the data between
Mysql> SELECT * FROM test where name is like ' app% '; # using a like query, refer to http://www.cnblogs.com/pzk7788/p/6899748.html
Mysql> SELECT * FROM test order by ID; # to sort the query results, refer to: http://www.cnblogs.com/pzk7788/p/6911594.html
MySQL>SelectId,name fromTest limit2; # query only the previous two data

MySQL query data