mysql插入数据 java_MySQL插入数据

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表结构一致，