MySQL Review Basics 3

1, limit [offset, 0 means no offset, in the first row, 1 for the offset line, in the second row; The default value is 0] the number of records to show

Application of pagination:

int curpage = 2;

int pageSize = 10;

int offSet = (curPage-1) * pageSize;

SELECT * from Limit offSet, rows;//rows the number of records to show

2, like fuzzy matching commonly used operators, to form a conditioned reflex.

3. Wildcard constant and like with and regular expression matching

From rookie tutorial: http://www.runoob.com/sql/sql-wildcards.html

4, in is commonly used in the WHERE clause multiple values, discontinuous filtering; if continuous, use between and or greater than

5, between, MySQL is a closed interval, with not, in, such as the following figure

Between operator with text value, date value, as shown in Figure two below: (citation: http://www.runoob.com/sql/sql-between.html)

6. Connect inner join (join); left Join;right Join;full join (including previous three types)

Specific can be consulted: Beginner's tutorial

Http://www.runoob.com/sql/sql-tutorial.html

MySQL Review Basics 3