1. 插入数据
插入完整的行
insert into customers values(null, 'Pep E. LaPew', '100 Main Street', 'Los Angeles', 'CA', '90046', 'USA', null, null);
按字段插入行
insert into customers(cust_name, cust_address, cust_city, cust_state, cust_zip, cust_country, cust_contact, cust_email) values('Pep E. LaPew', '100 Main Street', 'Los Angeles', 'CA', '90046', 'USA', null, null);
逐条插入多行
insert into customers(cust_name, cust_address, cust_city, cust_state, cust_zip, cust_country) values('Pep E. LaPew', '100 Main Street', 'Los Angeles', 'CA', '90046', 'USA');
insert into customers(cust_name, cust_address, cust_city, cust_state, cust_zip, cust_country) values('M. Martian', '42 Galaxy Way', 'New York', 'NY', '11213', 'USA');
一次性插入多行
insert into customers(cust_name, cust_address, cust_city, cust_state, cust_zip, cust_country) values('Pep E. LaPew', '100 Main Street', 'Los Angeles', 'CA', '90046', 'USA'), ('M. Martian', '42 Galaxy Way', 'New York', 'NY', '11213', 'USA');
插入检索出的数据
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;
1. 按字段插入要不直接插入更安全
2. 可以为null的字段可以省略,前后按一对一对应
3. 插入检索数据select insert
创建custnew与customers表结构一致,