MySQL 기본 문법

# USE
USE world; # db명

# 테이블 보기
SHOW TABLES;
SHOW TABLE STATUS; # 테이블 속성

# 테이블 열 확인
DESCRIBE city;
DESC city;

# 테이블 열 추출
SELECT * FROM city; # 전체
SELECT Name FROM city;

# WHERE
SELECT *
FROM city
WHERE Population > 100000;

# 관계 연산자
SELECT *
FROM city
WHERE Population > 100000 
AND Population < 200000;

# BETWEEN...AND 사이 값
SELECT *
FROM city
WHERE Population BETWEEN 100000 AND 200000;

# IN 이산 값
SELECT *
FROM city
WHERE Name IN('Seoul', 'New York', 'Tokyo');

# LIKE
SELECT *
FROM city
WHERE CountryCode LIKE 'KO_'; # _는 한글자 매치

SELECT *
FROM city
WHERE CountryCode LIKE 'K %'; # % 무엇이든 허용

# Sub Query
SELECT *
FROM city
WHERE CountryCode = (	SELECT CountryCode
                    	FROM city
                    	WHERE Name = 'Seoul'	);