Detailed explanation of MySQL database addition, deletion and modification operations

Detailed explanation of MySQL database addition, deletion and modification operations

Inserting 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);

The simple way to write it is to omit the field name, but all fields must be inserted.

Batch Insert

Efficiency issues of single and batch insertion

The efficiency of inserting multiple records in MySQL is greater than that of inserting a single record.

Deleting Records

delete from table name [where condition]

If no conditions are specified, all data in the table will be deleted one by one.

What is the difference between delete and truncate?

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

truncate: belongs to DDL, delete the table first and then rebuild it

Which one is more efficient in deleting data, delete or truncate?

If the data is small, delete is more efficient

If the amount of data is large, truncate is more efficient

Update Record

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

Modify multi-field data

Modify all (use with caution)

The above is a detailed explanation and integration of the MySQL database addition, deletion and modification operations introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!

You may also be interested in:
  • How to solve the problem of case insensitivity in MySQL queries
  • MySQL optimization strategy (recommended)
  • Detailed explanation of how MySQL solves phantom reads
  • Detailed explanation of the 10061 unknown error when using Navicat to connect to a remote Linux MySQL database
  • How to add index to mysql using shell script
  • MySQL character set garbled characters and solutions
  • MySQL starts slow SQL and analyzes the causes
  • Will MySQL execute the update statement again if it has the same data as the original one?
  • Reasons and solutions for slow MySQL query stuck in sending data
  • What should I do if I want to cancel an incorrect MySQL command?

<<:  Implementation of Nginx configuration of multi-port and multi-domain name access

>>:  Implementing access control and connection restriction based on Nginx

Recommend

Linux operation and maintenance basic swap partition and lvm management tutorial

Table of contents 1. Swap partition SWAP 1.1 Crea...

Commonly used English fonts for web page creation

Arial Arial is a sans-serif TrueType font distribu...

Using the outline-offset property in CSS to implement a plus sign

Assume there is such an initial code: <!DOCTYP...

Universal solution for MySQL failure to start under Windows system

MySQL startup error Before installing MySQL on Wi...

Practical way to build selenium grid distributed environment with docker

Recently, I needed to test the zoom video confere...

18 killer JavaScript one-liners

Preface JavaScript continues to grow and prosper ...

Teach you how to get the pointer position in javascript

The method of obtaining the position of the point...

A very detailed explanation of Linux C++ multi-thread synchronization

Table of contents 1. Mutex 1. Initialization of m...

Detailed explanation of this pointing in JS arrow function

Arrow function is a new feature in ES6. It does n...