从本表选择插入

2019独角兽企业重金招聘Python工程师标准>>>

insert into company(`cid`, `name`, `company`, `cellphone`, `address`, `picurl`, `intro`, `real_votes`, `votes`, `created`, `is_deleted`) select 38, `name`, `company`, `cellphone`, `address`, `picurl`, `intro`, `real_votes`, `votes`, `created`, `is_deleted` from company where id<=118

转载于:https://my.oschina.net/sharesuiyue/blog/788990