DML-插入语句 insert

# 插入语句

INSERT INTO job(name,job)

VALUES ('王五','市长');

# 插入子查询

INSERT INTO job(name,job)

SELECT name,job FROM job WHERE name='张三';

VALUSE和SET区别：

insert into table (field1,field2) values (value1,value2)

insert into table set field1 = value1,field2 = value2