Mysql查询一张表的数据新增到另一张表里

1.把B表的数据查询出新增到A表去

INSERT INTO a(id,name) SELECT b.id as id,b.name as name FROM b;

2.B表的字段满足不了A的情况下 ‘name’是对应type ，now()是对应的create_date

INSERT INTO dim_attach (type,bill_id,url,create_date) select 'name', a.id AS bill_id, a.head_address AS url,now() FROM dim_people a

mybatis写法 mapper.xml

<insert id="addDownLods" parameterType="com.entity.VideoDownLogs"> insert into video_down_logs(video_id, video_date, video_name, video_url, video_size, user_name, down_flag) select a.id as video_id ,a.load_time as video_date ,a.title as video_name,a.hdfs_url as video_url,a.size as video_size, #{userName} as user_name, 0 from video_origin a where 1=1 <if test="id !=null"> and a.id=#{id} </if> </insert>

values 不用写！！！！