插入数据
//可插入多行，速度比分开插入快
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必知必会
