插入完整的行

insert into customer values(200,'**贸易','**路*号','珠海市','广东',519000,'中国','张先生','zhang@126.com');  // 插入完整的行
insert into customer(cust_id,cust_name,cust_address,cust_city,cust_state,cust_zip,cust_conutry,cust_concact,email_email) values(200,'**贸易','**路*号','珠海市','广东',519000,'中国','张先生','zhang@126.com');  // 插入完整的行(更安全)

插入行的一部分

insert into customer(cust_id,email_email) values(200,'zhang@126.com');

插入多个行

insert into customer(cust_id,email_email) values(200,'zhang@126.com'),(201,'zhang@139.com');

插入检索出的数据

insert into customer(cust_id,email_email) select c_id,compy from database_compy.compy where c_id<=10;