[프로그래머스] SQL 쿼리문 정리

[프로그래머스] SQL 쿼리문 정리 #SQL 쿼리 #INSERT INSERT INTO member(ID, Name,Date, Num) VALUES(1, '장호연', '2022-02-11', 99); #UPDATE UPDATE member SET Num = 211 WHERE Name = '김철수'; #DELETE DELETE FROM member WHERE Name = '박해수'; #COLUMN 추가 ALTER TABLE member ADD mbti VARCHAR(20); # MAX SELECT MAX(DATETIME) FROM ANIMAL_INS; # NULL SELECT ANIMAL_ID FROM ANIMAL_INS WHERE NAME IS NULL WHERE NAME IS NOT NULL; # STR..