[MySQL] SQL 기본 문법(SELECT FROM WHERE)

1. USE

데이터베이스가 여러개일때 

USE MARKET_DB;
SELECT * FROM MARKET_DB.MEMBER;

근데

Error Code: 1064. You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the right syntax to use near 'MEMBER' at line 1

위와 같은 에러 발생하는 이유는 WORKBENCH 와 MYSQL 서버 버전이 안맞는 경우

 

 2. WHERE 조건식

SELECT * FROM MARKET_DB.MEMBER WHERE MEM_NAME = '블랙핑크';
SELECT MEM_ID, HEIGHT FROM MARKET_DB.MEMBER WHERE HEIGHT >= 165 AND MEM_NUMBER > 6;
SELECT MEM_ID, HEIGHT FROM MARKET_DB.MEMBER WHERE HEIGHT BETWEEN 163 AND 165;
SELECT MEM_ID, ADDR FROM MARKET_DB.MEMBER WHERE ADDR ='경기' OR ADDR = '전남';
SELECT MEM_ID, ADDR FROM MARKET_DB.MEMBER WHERE ADDR IN ('경기', '전남');
SELECT MEM_ID, MEM_NAME FROM MARKET_DB.MEMBER WHERE MEM_NAME LIKE '우%';
SELECT MEM_ID, MEM_NAME FROM MARKET_DB.MEMBER WHERE MEM_NAME LIKE '__핑크';

3. ALIAS 

SELECT HEIGHT 키 
FROM MARKET_DB.MEMBER 
WHERE MEM_NAME = '블랙핑크';


SELECT HEIGHT AS 키 
FROM MARKET_DB.MEMBER 
WHERE MEM_NAME = '블랙핑크';