How to update and delete MySQL

This article mainly shows you "how to update and delete MySQL". The content is simple and clear. I hope it can help you solve your doubts. Let me lead you to study and learn how to update and delete MySQL.

Update the UPDATE table name SET field 1 = value 1, field 2 = value 2. WHERE condition

Change the name corresponding to id 12 to Lao ha:

Update users SET name = 'Old Ha' where id = 12

2. Delete

You can delete one or more records in a table through DELETE

DELETE FROM table name WHERE condition

Delete the data for which id equals 9:

DELETE FROM users WHERE id = 9

Delete all data:

DELETE FROM table name

TRUNCATE deletion:

TRUNCATE TABLE table name

The difference between DELETE and TRUNCATE:

DELETE supports conditions, while TRUNCATE does not.

DELETE supports transaction rollback, but TRUNCATE does not.

DELETE cleanup is slower than TRUNCATE.

TRUNCATE self-increment initializes

Delete the table:

DROP TABLE table name 1, table name 2,...

Delete the database:

The name of DROP DATABASE database; the above is all the contents of this article "how to update and delete 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!