第8章插入更新与删除数据

插入更新与删除数据

内容导读

• 掌握如何向表中插入数据
• 掌握更新数据的方法
• 熟悉如何删除数据

---

插入数据

基本语法格式为:

INSERT INTO table_name (column_list) VALUES (value_list); 

为表的所有字段插入数据

Insert into person
VALUES (1,'Green', 21,'Lawyer'); 

为表的指定字段插入数据

Insert into person (id ,name, age, info) 
VALUES (2,'Green', 21,'Lawyer'); 

同时插入多条记录

INSERT INTO table_name (column_list) 
VALUES (value_ list I), (value_list2), ...(value_listn);

将查询结果插入到表中

INSERT INTO table_namel (column_Jistl) 
SELECT (column_list2) FROM table_name2 WHERE (condition)

INSERT INTO person(id, name, age, info) 
SELECT id, name, age, info FROM person_old; 

更新数据

UPDATE table name 
SET column_namel = value1,columo_name2=value2
WHERE (conditjon); 

UPDATE person 
SET age= 15, name='jim' 
WHERE id = 11; 

删除数据

DELETE FROM table_name [WHERE <condition>]; 

DELETE FROM person WHERE id= 11;