insert一个表的数据到另外一个表

insert into a(real_name,is_main,mobile,password,property_id,create_time) select linkman as real_name,'1',mobile,password,id as property_id,create_time from b

 

posted @ 2020-04-28 14:23  hjr_rong  阅读(941)  评论(0编辑  收藏  举报