查看Mysql服务器中的已有的数据库:
mysql> show databases;
执行结果:
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| stuexpm |
| sys |
| world |
+--------------------+
7 rows in set (0.00 sec)
创建名为stusys的学生信息数据库:
mysql> create database stusys;
执行结果:
Query OK, 1 row affected (0.00 sec)
选择数据库:
选择stusys当前数据库
mysql> use stusys;
执行结果:
Database changed
修改数据库:
修改数据库stusys的默认字符集和校队规则
mysql> alter database stusys
-> default character set gb2312
-> default collate gb2312_chinese_ci;
执行结果:
Query OK, 1 row affected (0.00 sec)
删除数据库:
删除数据库stusys
mysql> drop database stusys;
执行结果:
Query OK, 0 rows affected (0.00 sec)
查看现有的数据库
mysql> show databases;
执行结果:
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| stuexpm |
| sys |
| world |
+--------------------+
7 rows in set (0.00 sec)