DB/명령프롬프트 - mysql

[MySQL] Database 생성, 사용 create, use

congs 2023. 3. 27. 09:05

Database 생성 (create, use)

mysql> show databases; //mysql의 데이터베이스들
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
| test               |
| world              |
+--------------------+
7 rows in set (0.00 sec)

mysql> create database ezen; //ezen 생성
Query OK, 1 row affected (0.00 sec)

mysql> show databases; 
+--------------------+
| Database           |
+--------------------+
| ezen               |
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
| test               |
| world              |
+--------------------+
8 rows in set (0.00 sec)

mysql> use ezen; //ezen을 사용합니다
Database changed
mysql> show tables; //ezen의 테이블을 보여주세요
Empty set (0.00 sec)