INSERT INTO 表 (yuesao_openid, user_openid,time) SELECT xxxx as yuesao_id,id,'2017-11-23 10:09:24'as time from 表 LIMIT 20; 查询 20条数据 A表 并且给字段赋值 添加 到B 表
INSERT INTO t_belong_yuesao_vote (yuesao_id, user_openid,time)SELECT 'xxxxxx'as yuesao_id,openid,'2017-11-23 10:09:24'as time
from t_user_info LIMIT 20;