需求:将A表中指定查询条件的数据,插入到B表中。
INSERT INTO ap_base_categories (
category_name,
category_id,
parent_id,
level
,
tree,
site_code,
created_at,
is_leaf,
platform
) SELECT
category_name,
category_id,
parent_id,
level
,
tree,
site_code,
created_at,
is_leaf,
platform
FROM
ap_categories
WHERE
platform = 1
AND site_code = 'MY';
注意:字段要一一对应。
Original: https://www.cnblogs.com/camg/p/16512519.html
Author: 在斑马线上散布
Title: MySQL将一个表的数据插入到另外一张表中
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/602639/
转载文章受原作者版权保护。转载请注明原作者出处!