MySql queries the first n records

The first n records of MySql query SQL Server use top to query the first n rows of data. The syntax rule is: SELECT TOP number | percent column_name (s) FROM table_name [SQL] select top number | percent column_name (s) FROM table_name while Mysql uses limit: [SQL] SELECT column_name (s) FROM table_name LIMIT number. Example: [SQL] SELECT * FROM keywordtable limit; 0 can be omitted in the first statement. The default value is FROM the first statement. The second statement queries 2, 3, and 4 data records.