실습환경 만들기
CREATE DATABASE zerobase DEFAULT CHARACTER SET utf8mb4;
![](https://velog.velcdn.com/images/gmio/post/a475b810-f61c-42b5-b8ca-a29227767324/image.png)
Table
- 실제 데이터가 저장되는 형태
- 행(Row)과 열(Column)로 구성된 데이터 모음
Create Table
CREATE TABLE tablename
(
columnname datatype,
columnname datatype,
columnname datatype,
)
- Ex) id(int)와 name(varcher(16)) 칼럼을 가지는 mytable 이라는 이름의 테이블 생성
CREATE TABLE mytable
(
id int,
name varchar(16)
어ㄸ);
![](https://velog.velcdn.com/images/gmio/post/f4e71707-a21b-492a-b6d2-c80f2ba3125c/image.png)
SHOW TABLES;
![](https://velog.velcdn.com/images/gmio/post/1c38c868-5faa-49c0-be3d-b352e81c31c4/image.png)
DESC tablename;
![](https://velog.velcdn.com/images/gmio/post/a147976a-9f93-4a0f-813c-62ea5a30a308/image.png)
Table 이름 변경 문법
ALTER TABLE tablename
RENAME new_tablename
![](https://velog.velcdn.com/images/gmio/post/bc87f5a2-06bf-4f96-b1e1-6126ab862aff/image.png)
Table Column 추가
ALTER TABLE tablename
ADD COLUMN columnname datatype;
![](https://velog.velcdn.com/images/gmio/post/1e86b833-b2f5-4312-ad16-cade944117a2/image.png)
Table Column 변경
ALTER TABLE tablename
MODIFY COLUMN columnname datatype;
![](https://velog.velcdn.com/images/gmio/post/29e004bf-359c-4942-8307-0a6208e52a1d/image.png)
ALTER TABLE tablename
CHANGE COLUMN old_columnname new_columnname datatype;
![](https://velog.velcdn.com/images/gmio/post/5a35000b-10fe-409b-bd57-d447ccd4dab9/image.png)
Table Column 삭제
ALTER TABLE tablename
DROP COLUMN columnname;
![](https://velog.velcdn.com/images/gmio/post/ae9bdaba-b27a-4fcb-bf75-9c357c766285/image.png)
Table 삭제
DROP TABLE tablename;
![](https://velog.velcdn.com/images/gmio/post/cda9d751-cee7-40af-b8a4-60f0a82fd8d8/image.png)