MySQL learning five: SQL statement learning 3

Well, people think that this kind of font is still better looking, all of us to change such a font.

The INSERT INTO statement is used to insert a new row into the table.

Grammar

INSERT INTO 表名称 VALUES (值1, 值2,....)

We can also specify the columns to insert the data into:

INSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....)

The Update statement is used to alter the data in the table.

Grammar:

UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值

The DELETE statement is used to delete rows in a table.

Grammar

DELETE FROM 表名称 WHERE 列名称 = 值

Delete a row

"Fred Wilson" will be removed:

Delete all rows

The ability to delete all rows without deleting the table. This means that the structure, properties, and indexes of the table are complete:

  DELETE from table_name  or:  Delete * FROM table_name