The difference between truncate and delete commands in mysql

This article mainly introduces "the difference between truncate and delete commands in mysql". In daily operation, I believe many people have doubts about the difference between truncate and delete commands in mysql. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "the difference between truncate and delete commands in mysql". Next, please follow the editor to study!

In short, tables that are emptied with truncate id will rerecord, while tables emptied by delete will not continue to record the original data, of course, id is self-growing.

=

This article demonstrates how to use the truncate command and the difference between delete and truncate

Let's look at a section that deletes all data instances in a table.

Truncate table mytable

Use truncate to clear the table, and the id of the table starts from 1.

The following test example

Create table `user` (

`id`int (11) not null auto_increment

`name` varchar (100) default null

Primary key (`id`)

Insert several pieces of data

Insert into user (name) values ('bob')

Insert into user (name) values ('mark')

Insert into user (name) values ('alex')

Insert into user (name) values ('julia')

Take a look at the data

Select * from user; the result is:id name 1 bob 2 mark

3 alex 4 julia

Take a look at the truncate instance

Truncate table user

Insert a piece of data

Insert into user (name) values ('bill')

View the result

Select * from user

The result is:id name 1 bill

As you can see, the old record is deleted and the new one gets the id field 1

At this point, the study of "the difference between truncate and delete commands in mysql" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!