4. DB 추가, 삭제, 갱신, 조회

여러행 INSERT

INSERT INTO Person (Name, Birthday)

VALUES ('hihit44', '1994-11-11'), ('hihit55', '1994-11-12');

원하는 열 조회

SELECT Name FROM Person;

오름차순 조회

SELECT Name FROM Person ORDER BY Name;

내림차순 조회

SELECT Name FROM Person ORDER BY Name DESC;

SELECT WHERE

SELECT * FROM Person WHERE Name = 'hihit22';

LIKE

SELECT * FROM Person WHERE Birthday LIKE '1994%';