MySQL step by step...3

keer2345

三 添加,修改,删除记录

3.1 添加记录
>INSERT [LOW_PRIOTIRY | DELAYED] [IGNORE] [INTO]
  table_name [(column_list)]
  VALUES(col_1_value [,col_2_value]...)[,(...)]...;
或者
>INSERT [LOW_PRIOTIRY | DELAYED] [IGNORE] [INTO]
  table_name
  SET col_1=col_1_value[,col_2=col_2_value]...;
或者
>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

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/10869/showart_107489.html