MySQL插入数据insert

1. 插入数据

插入完整的行
SQL> insert into customers values(null, 'Pep E. LaPew', '100 Main Street', 'Los Angeles', 'CA', '90046', 'USA', null, null);

按字段插入行
SQL> 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);

逐条插入多行
SQL> 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');
SQL> 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');

一次性插入多行
SQL> 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');

插入检索出的数据
SQL> 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表结构一致，