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?