How to delete the first few rows in mysql

In mysql, you can delete the first few rows of data through the "delete from table_name where 1=1 order by order_name limit 100;" method.

Recommendation: "mysql video tutorial"

mysql deletes the first 100 data of a table

To delete the first 100 pieces of data, you must first sort and then delete the first 100 pieces of data.

sql statement format is:

delete from table_name where 1=1 order by order_name limit 100;

where table_name is the name of the table where you want to delete data, order_name is the field name by which field you want to sort, if the system automatically The default sorting, order by order_name does not need to be written.

The above is the detailed content of How to delete the first few rows in mysql. For more information, please follow other related articles on the PHP Chinese website!