pbj0812의 코딩 일기

0. 목표 - MySQL 에서 FULL JOIN 1. 실습 1) 테이블 생성 - like CREATE TABLE sql_test.like ( ID INT, LikeDate datetime ); - buy CREATE TABLE sql_test.buy ( ID INT, BuyDate datetime ); 2) 데이터 삽입 INSERT INTO sql_test.like(ID, LikeDate) VALUES(1, '2021-01-01'); INSERT INTO sql_test.like(ID, LikeDate) VALUES(1, '2021-01-02'); INSERT INTO sql_test.like(ID, LikeDate) VALUES(2, '2021-01-03'); INSERT INTO sql_test.li..