SELECT [์ปฌ๋ผ๋ช
]
FROM [ํ
์ด๋ธ ๋ช
]
WHERE [์กฐ๊ฑด๋ฌธ];
์ปฌ๋ผ๋ช
์๋ ์ฌ๋ฌ ๊ฐ์ ์ปฌ๋ผ์ ์ฌ์ฉํ ์ ์๊ณ , *์ ์
๋ ฅํ๋ฉด ๋ชจ๋ ์ปฌ๋ผ์ ์ถ๋ ฅํ๋ค.
WHERE์ ์ ์ฌ์ฉํ๊ฒ ๋๋ฉด ์กฐ๊ฑด๋ฌธ์ ํด๋นํ๋ ํ๋ง ์กฐํํ๋ค.
SELECT model_type FROM mytable;
SELECT * FROM mytable
WHERE model_num LIKE '13400%';
-- %๋ ์ด๋ค ๋ฌธ์๋ฅผ ํฌํจํ ๋ชจ๋ ๊ฒ์ ์กฐํํ๋ ๊ฒ์ด๋ค. (e.g. '13400%'๋ 13400K, 13400KF ๋ฑ์ ์ถ๋ ฅํ๋ค.)
-- _๋ ํ๊ฐ์ธ ๋จ์ด๋ฅผ ์๋ฏธํ๋ค. (e.g. '13400_'๋ 13400K, 13400F ๋ฑ์ ์ถ๋ ฅํ๋ค.
SELECT * FROM mytable
WHERE name = 'i5';
SELECT * FROM mytable
WHERE model_type = '๋ฉํฐ๋ ์ดํฌ'
LIMIT 1;
SELECT * FROM mytable
ORDER BY lowest_price DESC;
-- ASC๋ฅผ ์ฌ์ฉํ๋ฉด ์ค๋ฆ์ฐจ์, DESC๋ฅผ ์ฌ์ฉํ๋ฉด ๋ด๋ฆผ์ฐจ์ ์ ๋ ฌ
SELECT DISTINCT model_num FROM mytable;
SELECT DISTINCT model_num AS '๋ชจ๋ธ๋๋ฒ' FROM mytable;
์ถ๋ ฅ๋ ๋๋ ์ปฌ๋ผ๋ช ์ด ์ง์ ํ ์ด๋ฆ์ผ๋ก ์ถ๋ ฅ๋๋ค.
SELECT * FROM mytable
WHERE lowest_price BETWEEN 300000 AND 500000;
SELECT * FROM mytable
WHERE model_num IN ('13700K','13700KF');
SELECT model_num, AVG(lowest_price) FROM mytable
GROUP BY model_num;
SELECT model_num, AVG(lowest_price) FROM mytable
WHERE id >= 3
GROUP BY model_num
HAVING AVG(lowest_price) > 300000;
SELECT COUNT(lowest_price) FROM mytable;
SELECT COUNT(*) FROM mytable;
INSERT INTO [ํ
์ด๋ธ๋ช
]
([์ปฌ๋ผ๋ช
1], [์ปฌ๋ผ๋ช
2], ... )
VALUES ([๊ฐ 1], [๊ฐ 2], ...);
INSERT INTO mytable
VALUES(5, 'i5', '13400', '๋ฉํฐ๋ ์ดํฌ');
INSERT INTO mytable_test
SELECT * FROM mytable;
UPDATE [ํ
์ด๋ธ๋ช
]
SET [์ปฌ๋ผ๋ช
] = '๋ณ๊ฒฝํ ๊ฐ'
WHERE [์กฐ๊ฑด๋ฌธ];
UPDATE mytable SET model_type = '์๋๋ ์ดํฌ'
WHERE id = 2;
-- ๋ค์๊ณผ ๊ฐ์ด ์ฌ๋ฌ ๋ฐ์ดํฐ๋ฅผ ๋ณ๊ฒฝํ ์ ์๋ค.
UPDATE mytable SET name = 'i3', model_type = '์๋๋ ์ดํฌ'
WHERE model_num = '13700F';
DELECT FROM [ํ
์ด๋ธ๋ช
]
WHERE [์กฐ๊ฑด๋ฌธ];
๋ง์ฝ WHERE๋ฌธ์ ์ ๋ ฅํ์ง ์์๋ค๋ฉด ๋ชจ๋ ๋ฐ์ดํฐ๊ฐ ์ญ์ ๋๋ค.
ํ ์ด๋ธ์ ๋ชจ๋ ๋ฐ์ดํฐ๋ฅผ ์ญ์ ํ๊ณ ์ ํ๋ฉด DELECT * FROM ํ ์ด๋ธ๋ช ; ์ ์ฌ์ฉํ ์ ์๋๋ฐ, ์ด๋ DDL์์ TRUNCATE TABLE ํ ์ด๋ธ๋ช ; ๊ณผ ๊ฐ์ ๊ฒฐ๊ณผ๋ฅผ ๊ฐ์ง๋ง DELECT๋ฌธ์ ๋ฐ์ดํฐ๊ฐ ์ญ์ ๋์ด๋ ํ ์ด๋ธ์ ์ฉ๋์ ๊ฐ์ํ์ง ์๋ ๋ฐ๋ฉด, TRUNCATE๋ ๋ฐ์ดํฐ๊ฐ ์ญ์ ๋๊ณ ํ ์ด๋ธ์ ์ฉ๋๋ ์ด๊ธฐํ๋๋ค.