Easy to get started with MySQL-learning notes-Chapter 1 inserting, updating, and deleting data

ArticleDirectory

• 11.1.1 insert data for all fields in the table
• 11.1.2 insert data for specified fields in the table
• 11.1.3 insert multiple data records at the same time
• 11.1.4 insert query results into the table

11.1 insert data 11.1.1 insert data for all fields in the table

1. No specific field name is specified in the insert statement.

Insert into table name values (value 1, value 2... Value n)

2. List all fields in the insert statement

Insert into Table Name (attribute 1, attribute 2... Attribute N) values (value 1, value 2... Value n)

11.1.2 insert data for specified fields in the table

Insert into Table Name (attribute 1, attribute 2, attribute 3) values (value 1, value 2, value 3)

11.1.3 insert multiple data records at the same time

Insert into Table Name (attribute 1, attribute 2... Attribute N) values (value 1, value 2... Value n ),

(Attribute 1, attribute 2... Attribute N) values (value 1, value 2... Value n ),

...

(Attribute 1, attribute 2... Attribute N) values (value 1, value 2... Value N );

Unique to MySQL

11.1.4 insert query results into the table

Insert into Table Name (attribute 1, attribute 2... Attribute N)

Select attribute list from table name 2 Where condition expression

 

Use MySQL;

Create Table user1 (User char (16) not null );

Insert into user1 (User) Select User from user;

11.2. Update Data

Update table name

Set property 1 = value 1, property 2 = value 2 ,...

Where condition expression;

11.3 delete data

Delete from table name [condition expression];