[패스트캠퍼스] 데이터 분석 부트캠프 17기 - 7주차 (1) MySQL

1. 테이블에서 데이터 가져오기

USE [데이터베이스 이름];

SELECT [컬럼이름] FROM [테이블 이름];

 

2. 별명 붙이기 

SELECT [컬럼 이름] AS [별명] FROM [테이블 이름];

테이블 상의 컬럼이름은 바뀌지 않음

 

3. 데이터 일부만 가져오기

SELECT [컬럼 이름] FROM [테이블 이름] LIMIT 2;

 

4. 중복 제거하기

SELECT DISTINCT [컬럼 이름] FROM [테이블 이름];

 

5. (실습) 테이블에서 데이터를 가져와보자

 

MISSION (1)

SELECT 123*456;

 

MISSION (2) 

SELECT 2310 / 30;

 

MISSION (3)

SELECT '피카츄' AS '포켓몬';

 

MISSION (4)

USE pokemon;

SELECT * FROM mypokemon;

 

MISSION (5)

SELECT name FROM mypokemon ;

 

MISSION (6)

SELECT name, height, weight FROM mypokemon ;

 

MISSION (7)

SELECT DISTINCT height FROM mypokemon ;

 

MISSION (8)

SELECT attack*2 AS attack2 FROM mypokemon;

 

MISSION (9)

SELECT name AS 이름 FROM mypokemon;

 

MISSION (10)

SELECT attack AS 공격력, defense AS 방어력 FROM mypokemon;

 

MISSION (11)

SELECT height*100 AS 'height(cm) ' FROM mypokemon;

 

MISSION (12)

SELECT * FROM mypokemon LIMIT 1;

 

MISSION (13)

SELECT name AS '영문명', height AS '키(m)' , weight AS '몸무게(kg)'

FROM mypokemon

LIMIT 2;

 

MISSION (14)

SELECT name, attack+ defense +speed AS 'total' FROM mypokemon ;

 

MISSION (15)

SELECT name, weight/(height^2) AS 'BMI' FROM mypokemon ;