mysql-查询并且添加数据

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;
联系我们

邮箱 626512443@qq.com
电话 18611320371
QQ 626512443
QQ群 235681453

Copyright © 2015-2019

备案号:京ICP备15003423号-3