SQL) 데이터 조작 언어(insert, select, update, delete)

insert

 

insert into tablename(column1, column2, column3, column4, ...)
values (value1, value2, ...)

💥 데이터 타입 유의!

 

- 모든 컬럼값을 추가하는 경우

insert into tablename
values( vale1, value2, ...)

💥 컬럼 순서 유의!

 

select

 

select column1, column2, ...
from tablename;

 

where

 

select column1, column2, ...
from tablename
where condition;

update

update tablename
set column1 = value1, column2 = value2, ...
where condition;

delete

delete from tablename where condition;

order by

select column1, column2, ...
from tablename
order by column1, column2, ... asc|desc;