Notice
Recent Posts
Recent Comments
Link
์ผ | ์ | ํ | ์ | ๋ชฉ | ๊ธ | ํ |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 |
Tags
- ๊ฐ๋ฐ
- JavaScript
- ๋ ์
- ๊น๋ฏธ๊ฒฝ์๋งํ์์
- ComputerScience
- ํ๋ก๊ทธ๋๋ฐ
- ์นํ์ด์ง๋ง๋ค๊ธฐ
- ๋ฐ์ํ
- ์๋ฐ์คํฌ๋ฆฝํธ
- ๋ง์ผ๋ด๊ฐ์ธ์์๋ค์์ฐ๋ค๋ฉด
- html
- K๋ฐฐํฐ๋ฆฌ๋ ๋ณผ๋ฃจ์
- ๊นํ๋จ
- Python
- ์๋ฐ
- css
- ์ฑ
- ํ์ด์ฌ
- ์ฝ๋ฉ
- K๋ฐฐํฐ๋ฆฌ
- database
- ์ค๋ผํด
- ๋ผํ๋ผ์ค์๋ง๋
- Java
- ์นํผ๋ธ๋ฆฌ์ฑ
- ๋ฐ์ดํฐ๋ฒ ์ด์ค
- ๊น๋ฏธ๊ฒฝ
- ์ปดํจํฐ๊ณผํ
- ์ฅํธ์์ค
- ์ํ
Archives
- Today
- Total
JiYoung Dev ๐ฅ
[database ๊ณ ๊ธ] CTAS (2023.08.08) ๋ณธ๋ฌธ
๋ฐฑ์ ํ ์ด๋ธ ์์ฑ
CTAS : CREATE TABLE AS SELECT(CTAS) SELECT ๋ฌธ์ ๊ฒฐ๊ณผ๋ก๋ถํฐ ์ ํ ์ด๋ธ์ ์์ฑํ๋ค.
CREATE TABLE TB_CUST_BAK AS SELECT * FROM TB_CUST;
--๋ฐ์ดํฐ์ ์๋ฃํ๊น์ง ํ๋ฒ์ ๋ค์ด๊ฐ(PK, FK ๋ณต์ฌ๋ ๋ถ๊ฐ)
CREATE TABLE TB_CUST_BAK AS SELECT * FROM TB_CUST WHERE 1=0;
-- TB_CUST์ ๋๊ฐ์ ํํ์ ํ
์ด๋ธ ์์ฑ (๋ฐ์ดํฐ X)
'full stack > database' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
[database ๊ณ ๊ธ] ์๋์ฐ ํจ์ (2023.08.09) (0) | 2023.08.09 |
---|---|
[database ๊ณ ๊ธ] ์งํฉ์ฐ์ฐ์ (2023.08.08) (0) | 2023.08.08 |
[database ๊ณ ๊ธ] merge (2023.08.08) (0) | 2023.08.08 |
[database ๊ณ ๊ธ] case๋ฌธ (2023.08.08) (0) | 2023.08.08 |
[database ๊ณ ๊ธ] EXISTS (2023.08.07) (0) | 2023.08.07 |