SQL插入语句

插入语句 INSERT

--建表
CREATE TABLE student (sid integer,sname varchar(10),haddress varchar(20);

插入数据

单条数据：

INSERT INTO student (sid,sname,haddress) VALUES (21,'小明','北京');

多条数据

INSERT INTO student (sid,sname,haddress) VALUES (21,'小明','北京'),
										VALUES (22,'张三','上海'),
										VALUES (23,'李四','深圳');

从其他表中复制数据

建表

CREATE TABLE studentcopy (sid integer,sname varchar(10),haddress varchar(20);

插如所有值

INSERT INTO studentcopy (sid,sname,haddress)
SELECT sid,sname,haddress
FROM student ;

插入符合要求的值

INSERT INTO studentcopy (sid,sname,haddress)
SELECT sid,sname,haddress
FROM student 
WHERE sname='张三';