MySQL Database
์คํค๋ง(schema),
id
title
description
created
1
MySQL
MySQL is ..
2018-1-1
2
Oracle
Oracle is ...
2018-1-3
์์ ๊ฐ์ ํ(table)๊ฐ ์ฌ๋ฌ๊ฐ ์์ฑ๋๋ค.
์คํค๋ง(schema) : MySQL์์๋ ์๋ก ์ฐ๊ด๋ table๋ค์ Groupingํ๊ฒ์ ๋ฐ์ดํฐ๋ฒ ์ด์ค(database)๋ผ๊ณ ํ๋ค.
๋ฐ์ดํฐ๋ฒ ์ด์ค ์๋ฒ(database server) : ์คํค๋ง๋ค์ ์ฌ๋ฌ๊ฐ ํฌํจํ ๊ฒ

Database(Schema) ์ค์ตํ๊ธฐ
์์ฑํ๊ธฐ
mysql> CREATE DATABASE opentutorials;
Query OK, 1 row affected (0.03 sec)
์ญ์ ํ๊ธฐ
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name
mysql> DROP DATABASE opentutorials;
Query OK, 0 rows affected (0.04 sec)
๋ณด๊ธฐ
SHOW {DATABASES | SCHEMAS}
[LIKE 'pattern' | WHERE expr]
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| opentutorials |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.01 sec)
์ฌ์ฉํ๊ธฐ
mysql> USE opentutorials;
Database changed
Last updated
Was this helpful?