MySql 插入数据

插入数据

//可插入多行，速度比分开插入快
insert into customers(cust_name,
               cust_address,
               cust_city,
               cust_state,
               cust_zip,
               cust_country,
               cust_contact,
               cust_email)
              values('Pep E. La',
                  '100 main stree',
                  'Los Angelas',
                  'ca',
                  '90045',
                  'usa',
                  null,
                  null),
                  ('Pep',
                  '100 main',
                  'Los',
                  'ca',
                  '90045',
                  'usa',
                  null,
                  null);
                  

插入检索出来的数据

//这个例子导入了cust_id（要确保cust_id的值不重复），你也可以省略这列

insert into customers(cust_id,
               cust_contact,
               cust_email,
               cust_name,
               cust_address,
               cust_city,
               cust_state,
               cust_zip,
               cust_country)
             select cust_id
                  cust_contact,
                  cust_email,
                  cust_name,
                  cust_address,
                  cust_city,
                  cust_state,
                  cust_zip,
                  cust_country
            from custnew;

参考书籍：

• MySQL必知必会