mysql_tips

2021-04-13  本文已影响0人  弦好想断

https://www.bilibili.com/video/BV1PU4y1p7jP

insert into table_2 (promotion_price,promotion) SELECT 字段1,字段2,...  FROM table_1 where table_1.id is not in (
select id from  table_2 );
上一篇 下一篇

猜你喜欢

热点阅读