插入數(shù)據(jù)
//可插入多行的榛，速度比分開插入快
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);
插入檢索出來的數(shù)據(jù)
//這個(gè)例子導(dǎo)入了cust_id（要確保cust_id的值不重復(fù)）摄职，你也可以省略這列
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必知必會
