MySQL Data manipulation

1. Inserting a single row of data

INSERT into table_name SET

< field 1>= value 1,

< field 2>= Value 2,

< field n>= value N;

INSERT into T1 SET

Id=1,

Name= ' Zhangsan ',

sex= ' F ';

2. Inserting multiple rows of data

INSERT into table_name

[(Field 1, Field 2, field N)]

VALUES

(value 1, value 2, Value N), (value 1n, value 2n, value 3n);

3. Inserting query results into a table

INSERT into table_name1

(Field 1, Field 2, field N)

SELECT field A, field B, field C from

Table_name2

[WHERE condition];

4. Updating data

UPDATE table_name1 SET

field 1= value 1, field 2= value 2, field n= value n

[WHERE condition];

UPDATE T1

SET

Name= ' Tom '

WHERE

id=2;

Delete data

DELETE from table_name

[WHERE <condition>];

Thing operation

Using tables in the INOODB data engine to support thing operations

By default, MySQL turns on auto-commit

Regin Open a Thing

Rollback rolling back a thing

Commit Commit a thing

MySQL Data manipulation