Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to add, delete and change operations in mysql database. The content of the article is of high quality, so Xiaobian shares it with you for reference. I hope you have a certain understanding of relevant knowledge after reading this article.

insert data

insert into table name (column name 1, column name 2, column name 3) values(value 1, value 2, value 3);

insert into user(user_id,name,age) values(1,'nice',24);

Simple writing can omit field names, but insert all fields.

bulk inserts

Efficiency of Single Insertion and Batch Insertion

mysql multiple data insertion efficiency is greater than single data insertion

delete records

delete from table name [where condition]

If no condition is specified, all data in the table will be deleted one by one.

What is the difference between deleting data and truncating data?

delete: belongs to DML and deletes data in the table one by one

truncate: belongs to DDL, delete tables first and then rebuild them

Delete or truncate, which deletes data efficiently?

If the data is small, delete is more efficient.

If the data volume is large, truncate is more efficient.

update history

update table name set column name = column value, column name 2= column 2 value [where condition]

Modify multi-field data

All modifications (caution)

About how to add, delete and change operations in mysql database to share here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

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.