1. select select [열] from [테이블] -- 중복제거 select DISTINCT [컬럼명] from [테이블] 2. insert insert into [테이블명] (필드명1, 필드명2, 필드명3, ...) values (필드값1, 필드값2, 필드값3, ...) 3. update update [테이블] set [열1] = '변경할 값', [열2] = '변경할 값' where [조건] update [테이블1] a inner join [테이블2] b on a.[조인할 컬럼명] = b.[조인할 컬럼명] set a.[변경할 컬럼명] = [변경할 값], b.[변경할 컬럼명] = [변경할 값] ... 4. delete delete from [삭제할 테이블] 5. join select 열1, 열2 ..
