mysql insert into select

member_tmp数据组装插入c_members表

    insert into c_members (identity,phone,email,name,qq,fax,tel,company_id,user_id) select 'buyer,seller',phone,email,`name`,qq,fax,mobile,company_id,18 from member_tmp