SQL 기초(3)

• SELECT 문법

SELECT column1, column2, ...
FROM table_name;

• SELECT 컬럼 보기

SELECT *           # "*"은 모든 컬럼 | * or 컬럼이름
FROM table_name;

• WHERE 문법

SELECT column선택
FROM table_name
WHERE condition;

• UPDATE 문법

UPDATE table_name 
SET column_name = value
WHERE condition;

• DELETE 문법

DELETE FROM table_name
WHERE condition;