1. 普通插入,执行普通的插入语句
insert into colors (goods_id,color,sale_num) values(3533,'蓝色',0);
2. 不同表选择插入,用以执行表备份操作
insert into db1.brand (id,brand_name,created_at,updated_at,display_name) select id,name,created_at,updated_at,name from db2.store_brands
1. 普通插入,执行普通的插入语句
insert into colors (goods_id,color,sale_num) values(3533,'蓝色',0);
2. 不同表选择插入,用以执行表备份操作
insert into db1.brand (id,brand_name,created_at,updated_at,display_name) select id,name,created_at,updated_at,name from db2.store_brands