>INSERT [LOW_PRIOTIRY | DELAYED] [IGNORE] [INTO]
table_name [(COLUMN_LIST)]
SELECT select_statements;
例子:
(1)指定所有的列值:
>insert into product
values("00101","钢笔","支",25.60,"香港");
>insert into product
values("00102","钢笔","支",0.00,NULL);
>insert into product
values
("00101","钢笔","支",25.60,"香港"),
("00102","钢笔","支",0.00,NULL);
>insert into product (no,name,place)
values("00102","钢笔",NULL);
(2)使用 SET 赋值
>insert into product
set no="00101",name="钢笔",place="香港";
(3)通过 SELECT 添加记录
>create table product_1
select * from product
where 1=0;
>insert into product_1
values
("00110","音像",200,"深圳"),
("00111","主板",900,"东莞");
>insert into product
select * from product_1;
page109
| 网站地图 |