Shulou(Shulou.com)06/01 Report--

Editor to share with you how many lines in mysql deleted before the case, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to understand it!

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

Mysql deletes the first 100 pieces of data from a table

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

The format of the sql statement is:

Delete from table_name where 1 # 1 order by order_name limit 100

Where table_name is the table name where you want to delete the data, and order_name is the field name by which you want to sort the data. If you use the system automatic default sorting, you can leave this part of order by order_name unwritten.

The above is all the contents of the first number of lines deleted in mysql. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.