MySQL USE

MySQL use

1 실습

[root@jmnote ~]# mysql -uroot -pP@ssw0rd
Welcome to the MySQL monitor.  Commands end with ; or \g.
... (생략)

mysql> SHOW TABLES;
ERROR 1046 (3D000): No database selected

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.00 sec)

mysql> USE mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> SHOW TABLES;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| db                        |
| event                     |
... (생략)
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
23 rows in set (0.00 sec)

2 같이 보기

• SHOW DATABASES

3 참고 자료

• http://dev.mysql.com/doc/refman/5.0/en/creating-database.html