테이블명은 소문자로!

CREATE TABLE persionTable (
    PersonID int,
    FirstName varchar(255),
    LastName varchar(255),
    Address varchar(255),
);

SELECT (조회)

SELECT * FROM persionTable // persionTable 테이블의 모든 데이터를 가져옴

• DISTINCT : SELECT할때 고유한 값만 반환(중복제거)

SELECT DISTINCT LastName, FirstName FROM persionTable // persionTable 테이블에서 LastName, FirstName이 중복되지않게 가져옴

SELECT COUNT(DISTINCT LastName) FROM persionTable // 중복되지않는 LastName의 row수 반환

WHERE

SELECT 컬럼1, 컬럼2 FROM 테이블명 WHERE 조건

AND, OR

SELECT * FROM persionTable WHERE FirstName="김" AND LastName="태완"

SELECT * FROM persionTable WHERE FirstName="김" OR FirstName="박"

SELECT * FROM persionTable WHERE NOT FirstName="김"

SELECT * FROM persionTable WHERE FirstName="김" AND (LastName="태완" OR LastName="태송")

IS NULL / IS NOT NULL

SELECT * FROM persionTable WHERE FirstName IS  NULL

SELECT * FROM persionTable WHERE FirstName IS NOT NULL

ORDER BY

SELECT * FROM persionTable ORDER BY FirstName ASC  // ASC 생략가능

SELECT * FROM persionTable ORDER BY FirstName DESC

INSERT INTO (추가)

INSERT INTO persionTable (PersonID,FirstName, LastName,Address)
VALUES ("1", "김", "태완", "동작구대방동..")

UPDATE (변경)

UPDATE persionTable SET FirstName = "이", LastName = "순신"  WHERE PersonID = 1