How to delete data in mysql table

This article mainly introduces how to correctly delete data in the mysql data table.

MySQL is the most popular relational database management system. For professional developers, the basic operation of deleting data in the mysql table cannot be simpler. But for novices, they may have some questions when deleting data. For example, when we delete a certain table data through Navicat (a database management tool with a graphical user interface) and then add new data, we will find that the id has changed.

Recommended tutorial: "mysql tutorial"

Below we will explain to you through specific examples how to correctly delete data in the mysql table.

1. Delete a certain piece of data in the table

For example, there is a money table here. If we want to delete the data with id 2, we can click delete directly. The recording operation is as follows.

Then we add another piece of data. As shown below, we can find that the id is automatically 3.

If we want the id to return to normal increment, we can open the design table.

In the options column, just modify the auto-increment item.

2. Clear the specified data table

Here we choose to clear the money data table.

After clearing the data table, you can find that when we add new data, the id is still incremented from the previously cleared data.

Then when we want to clear the data table and add new data, the id can be incremented normally. You can choose to truncate the table, the operation is as follows:

After truncating the table, we can find that the id is incremented normally by entering new content.

This article is about how to correctly delete data in the mysql data table. It is very simple and easy to understand. I hope it will be useful to friends who need it. s help.

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