INSERT INTO billentity_base SELECT
*
FROM
billentity_base
WHERE
tenant_id IN (
SELECT
tenant_id
FROM
billentity_base
WHERE
tenant_id NOT IN ( '0', '1292161350684928' )
GROUP BY
tenant_id;);
楼上需求:同时要把新增的这些行数据的tenant_id列的值统一修改为aaa
简单版(MySQL将一张表的某些列数据,复制到另外一张表,并且修改指定内容)
INSERT INTO t_topic_content(content,topicId) SELECT REPLACE(content, 'aa', 'bb'),id FROM t_topic解析:replace(content,‘aa’,‘bb’)意为将表里原内容为aa的content列改为bb