◆ INSERT 문
- 데이터 입력
- 입력하지 않은 값은 자동으로 NULL 값 입력
● 컬럼 지정 입력
INSERT INTO [테이블명](컬럼1, 컬럼2,...) VALUES(컬럼1의 값, 컬럼2의 값,...);
ex)
![](https://blog.kakaocdn.net/dn/BIbSV/btsxicoBXod/xXPDO7pqagBxAw0szgYapK/img.png)
● 전체 입력
INSERT INTO [테이블명] VALUES(전체 컬럼의 값);
ex)
![](https://blog.kakaocdn.net/dn/c8HDxc/btsxvFJc37C/GXUAThkLtqBRJKxPEtYMek/img.png)
● 여러 레코드(튜블) 입력
INSERT INTO [테이블명] VALUES(전체 컬럼의 값), (전체 컬럼의 값)...;
ex)
![](https://blog.kakaocdn.net/dn/D2Er7/btsxrlYZ90D/aJn41sPi0FBvH4pF8tCfik/img.png)
데이터베이스, 테이블 생성
![](https://blog.kakaocdn.net/dn/yuqhK/btsxsRpNlK6/wYv9Uk0d0cHzajsK5zbSk1/img.png)
< book >
bookno
|
title
|
author
|
company
|
|
|
|
|
|
|
|
|
< customer >
name
|
id
|
pw
|
tel
|
|
|
|
|
|
|
|
|
table book
![](https://blog.kakaocdn.net/dn/bePlRO/btsxvHttYIs/qnmQp6eBWMKdwu3gdEXkbK/img.png)
![](https://blog.kakaocdn.net/dn/bAF5V5/btsxsnvwWZQ/dBAR3t5B7l85AknXnkj0Yk/img.png)
.
.
.
![](https://blog.kakaocdn.net/dn/cOsNEN/btsxkhwBMry/fJ6GiiwXBIeIIKm99uHjg0/img.png)
table customer
![](https://blog.kakaocdn.net/dn/uDltV/btsxp7mFlvs/r7Y94ZN9TnEK9DC5Il7k1k/img.png)
![](https://blog.kakaocdn.net/dn/BU6lv/btsxzZngoPg/pNH67mL9ByTTRFqk9FUku0/img.png)
.
.
.
![](https://blog.kakaocdn.net/dn/bzp6H7/btsxigYPDWZ/hoHLyglINUtnj3cIkKAVKK/img.png)
◆ SELECT 문
- 데이터 조회
- 테이블의 자료를 표 형식으로 조회
● 테이블의 모든 자료 조회
SELECT * FROM [테이블명];
ex)
![](https://blog.kakaocdn.net/dn/sqTJz/btsxtUs13Rc/wXLC0RuJLgmAeLfgfXEMy0/img.png)
![](https://blog.kakaocdn.net/dn/pbMqG/btsxqy5qme6/CkgTLtNK0wlBoo9GioPWaK/img.png)
● 테이블의 특정 컬럼 조회
SELECT 컴럼1, 컬럼2,... FROM [테이블명];
ex)
![](https://blog.kakaocdn.net/dn/bsqITa/btsxH1yhLeb/asoFrZkynLND7sQChaezx0/img.png)
![](https://blog.kakaocdn.net/dn/oF1LM/btsxq4QJg0q/1BA7AD2yUuc9nU2ZTnrZzk/img.png)
● 조건을 이용한 모든 자료 조회
SELECT * FROM [테이블명] WHERE 조건;
ex)
![](https://blog.kakaocdn.net/dn/doTfwv/btsxrjtoKkP/YAMiSAgLoCUBY2xJMkrda0/img.png)
![](https://blog.kakaocdn.net/dn/bQuv9L/btsxtlK1vFS/gK8FBqR1byGTpldh3dQkZk/img.png)
● 조건을 이용한 특정 컬럼 조회
SELECT 컬럼1, 컬럼2,... FROM [테이블명] WHERE 조건;
ex)
![](https://blog.kakaocdn.net/dn/baouOp/btsxvFJc37t/Sal9Se6iQW2J9iHJ0KpR2k/img.png)
![](https://blog.kakaocdn.net/dn/Sgmnh/btsxp9dKfUZ/o1kO93RWkSXSKaimxHYNgK/img.png)
+
![](https://blog.kakaocdn.net/dn/Om6U3/btsxrk6Tj95/cm5z9lM4n0qI9oH10K45XK/img.png)
![](https://blog.kakaocdn.net/dn/cCiNvE/btsxiefB0XQ/Qsa0l0WRc0Z5KaoBO0Rvk0/img.png)
![](https://blog.kakaocdn.net/dn/kHDRx/btsxsl5AGHu/03XF5U6q7GPEObDBae0L6K/img.png)
![](https://blog.kakaocdn.net/dn/4tb7r/btsxH1E4BK3/KHgiGOlf5K6RYro8YO2Llk/img.png)
![](https://blog.kakaocdn.net/dn/mydFw/btsxtUmgHQU/nNuTrAq1kFkZ8SQ1uyXpp0/img.png)
![](https://blog.kakaocdn.net/dn/ImPDk/btsxqrZI1uf/2KqnOKOSBoLgY5n68ntkuK/img.png)
![](https://blog.kakaocdn.net/dn/bAhLdU/btsxrYpaX00/hrN3nKMYk7tjcD3pGBbPb0/img.png)
![](https://blog.kakaocdn.net/dn/EMkFG/btsxie7MAQS/ZAyr7v8mvZXdZkHvRY1ZJ1/img.png)
![](https://blog.kakaocdn.net/dn/JG1r6/btsxz1k4pcO/3m0VILLSHkhVsf7KTK1KB0/img.png)
![](https://blog.kakaocdn.net/dn/eN7whO/btsxq4woni2/kIRXAn88VIuX3IouiK4MF0/img.png)
![](https://blog.kakaocdn.net/dn/bUNDwh/btsxtnB2XCC/jqbR66s3qVoLMq5pvKqnB1/img.png)
![](https://blog.kakaocdn.net/dn/cggwV7/btsxtmiQhTl/qWR27kktMFXaRFysvCbzI1/img.png)
![](https://blog.kakaocdn.net/dn/O6pFq/btsxtW5snUe/aSJLBnfqkptUWUkPO9uMz0/img.png)
![](https://blog.kakaocdn.net/dn/bPxQcs/btsxH07d6Op/RIwkv9bHM89utQW9hqNeE1/img.png)
![](https://blog.kakaocdn.net/dn/DnCzs/btsxgZCWS88/ZY2KFKcYJt6oNPYBxijZD0/img.png)
![](https://blog.kakaocdn.net/dn/wYUCf/btsxh9envCR/1qXp9gd8JB1Gp9ZTauY31k/img.png)
![](https://blog.kakaocdn.net/dn/nWbCK/btsxvFJc37y/YJFuUvZEpG0cJL7hdYLWW0/img.png)
◆ UPDATE 문
- 데이터의 내용 변경
- 조건 없으면 전체지정
● 테이블의 컬럼 값 수정
UPDATE [테이블명] SET [컬럼명] = [변경할 값] WHERE 조건;
![](https://blog.kakaocdn.net/dn/bpJfOp/btsxrkZ941U/Ii50JD9jl0y2KRyw4QXMq0/img.png)
![](https://blog.kakaocdn.net/dn/bDRT6M/btsxp5WTBu6/hSSs8LBupAtMQ1jJvC7qlK/img.png)
+
![](https://blog.kakaocdn.net/dn/bdCQHK/btsxsUz14p6/yZg7OhW6PzPIhzTT6uunu1/img.png)
![](https://blog.kakaocdn.net/dn/OgMDY/btsxq1sU7Ue/EqbkwbgeYnaeJRdR1H6pWK/img.png)
![](https://blog.kakaocdn.net/dn/emubEm/btsxkhJ7VQd/q8QbKx7yWKGkDBuqz3o5Q1/img.png)
![](https://blog.kakaocdn.net/dn/SWE2j/btsxrY3L8la/mCTEOKHTsX5Bes3KVhekdK/img.png)
![](https://blog.kakaocdn.net/dn/bBKe9M/btsxHZHfSIy/Ww8ZO9DESEPABVlteL4DAK/img.png)
◆ DELETE 문
- 데이터 내용 삭제
- 조건 없으면 전체지정
DELETE FROM [테이블명] WHERE [컬럼명] = 조건;
![](https://blog.kakaocdn.net/dn/dhvQ0w/btsxkFD1vfI/IIYpZ56gyrLEpWkpFFArh0/img.png)
'DBMS(SQL)' 카테고리의 다른 글
DBMS 실습 - SQL 함수 [자주쓰는 함수] - 2 (5, 6일차) (0) | 2023.10.09 |
---|---|
DBMS 실습 - SQL 함수 [자주쓰는 함수] - 1 (5, 6일차) (0) | 2023.10.09 |
데이터모델링, ERD(Entity Relationship Diagram) (3일차) (0) | 2023.10.09 |
DBMS실습 - CREATE, ALTER, DROP(2,3일차) (0) | 2023.10.09 |
DBMS 개념정리(1, 2일차) (0) | 2023.10.09 |