[MySQL] Database 생성

[MySQL] MySQL DB 생성

mysql> create database springDB;

Query OK, 1 row affected (0.00 sec)

mysql> create schema springDB default character set utf8;

Query OK, 1 row affected (0.01 sec)

mysql> create database springDB default character set utf8;

mysql> create database springDB default character set utf8 COLLATE utf8_general_ci;

mysql > create database if not exists springDB default character set utf8 COLLATE utf8_general_ci;

## 각각의 캐릭터 셋을 변경 - 이 변경 방법은 mysql 데몬이 재실행 될경우에 초기화 됨.

mysql> SET character_set_server = utf8;
mysql> SET character_set_client = utf8;
mysql> SET character_set_results = utf8;
mysql> SET character_set_connection = utf8;

mysql> ALTER DATABASE DB명 DEFAULT CHARACTER SET utf8;

[MySQL] DB 캐릭터셋 수정

mysql> alter database springDB default character set utf8 collate utf8_general_ci;

Query OK, 1 row affected (0.02 sec)