단축키

show databases;

mysql에 저장된 데이터베이스를 보여준다

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| ai_college         |
| atlas              |
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
| web_test           |
| world              |
| yogi_otte          |
+--------------------+
10 rows in set (0.00 sec)

 

create database (database name);

데이터베이스 생성한다

mysql> create database forDrop;
Query OK, 1 row affected (0.01 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| ai_college         |
| atlas              |
| fordrop            |
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
| web_test           |
| world              |
| yogi_otte          |
+--------------------+
11 rows in set (0.00 sec)

 

drop database (database name);

데이터베이스를 삭제한다

mysql> drop database forDrop;
Query OK, 0 rows affected (0.02 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| ai_college         |
| atlas              |
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
| web_test           |
| world              |
| yogi_otte          |
+--------------------+
10 rows in set (0.00 sec)

 

 

use (database name);

데이터베이스 안으로 들어간다

mysql> use yogi_otte;
Database changed

 

show tables;

데이터베이스의 테이블을 보여준다

mysql> show tables;
+------------------------------+
| Tables_in_yogi_otte          |
+------------------------------+
| auth_group                   |
| auth_group_permissions       |
| auth_permission              |
| custom_user                  |
| custom_user_groups           |
| custom_user_user_permissions |
| django_admin_log             |
| django_content_type          |
| django_migrations            |
| django_session               |
| review                       |
| store                        |
| store category               |
+------------------------------+
13 rows in set (0.00 sec)

 

select * from (table name);

테이블 안의 내용을 보여준다

mysql> select * from custom_user;
+----+------------------------------------------------------------------------------------------+----------------------------+--------------+----------+------------+-----------+----------------+----------+-----------+----------------------------+
| id | password                                                                                 | last_login                 | is_superuser | username | first_name | last_name | email          | is_staff | is_active | date_joined                |
+----+------------------------------------------------------------------------------------------+----------------------------+--------------+----------+------------+-----------+----------------+----------+-----------+----------------------------+
|  1 | pbkdf2_sha256$320000$57nZHG4BnCsvD29KMkdKuz$xv1woM3RgPs59G5kkElVbBpOVL8Wfitdk4EaOiGF8fU= | 2022-06-06 03:49:18.048869 |            1 | user     |            |           | user@naver.com |        1 |         1 | 2022-06-06 03:46:41.897670 |
+----+------------------------------------------------------------------------------------------+----------------------------+--------------+----------+------------+-----------+----------------+----------+-----------+----------------------------+
1 row in set (0.00 sec)