1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
INSERT INTO table_b (fbid, date_stat, post_video_views) VALUE
(1, '2022-01-01', 1),
(2, '2022-01-01', 2),
(3, '2022-01-01', 3);
INSERT INTO table_a (fbid, date_stat, post_video_views) VALUE
(1, '2022-01-01', 10),
(4, '2022-01-01', 4);
UPDATE table_b a, table_a b
SET a.post_video_views = b.post_video_views
-- etc
WHERE b.fbid = a.fbid
AND b.date_stat = a.date_stat;
DELETE
FROM table_a
WHERE EXISTS(SELECT 1 FROM table_b a WHERE table_a.fbid = a.fbid AND table_a.date_stat = a.date_stat);
INSERT INTO table_b (fbid, date_stat, post_video_views)
SELECT fbid, date_stat, post_video_views
FROM table_a; |
Partager