Mysql基础第二十二天,插入数据

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;