Some basic MySQL operations

Recently began to learn MySQL, mainly through books, and see Yan 18 teacher's video, and then through the blog to record their learning process.

Log in to Database

View all current databases

Mysql> show databases, #查看当前所有数据库 +--------------------+| Database           |+--------------------+| information_schema | | Ceshi              | | mysql              | | performance_schema |+--------- -----------+4 rows in Set (0.04 sec)

Create a database Ceshi1

mysql> CREATE database ceshi1; #创建数据库ceshi1Query OK, 1 row Affected (0.00 sec) mysql> show databases; #查看当前所有数据库 will see now One more ceshi1+--------------------+|. Database           |+--------------------+| information_schema | | Ceshi              | | ceshi1             | | mysql              | | performance_ Schema |+--------------------+5 rows in Set (0.00 sec)

to view the definition of a database ceshi1

Mysql> Show Create Database ceshi1, #查看数据库ceshi1的定义 +----------+------------------------------------------------- ------------------+| Database | Create Database                                                   |+----------+-------------------------------------------------------------------+| ceshi1   | CREATE DATABASE ' ceshi1 '/*!40100 DEFAULT CHARACTER SET latin1 */|+----------+---------------------------------------- ---------------------------+1 Row in Set (0.00 sec)

Delete Database Ceshi1

mysql> drop database ceshi1; #删除数据库ceshi1Query OK, 0 rows affected (0.07 sec) mysql> show databases; #查看当前所有数据库, you will now find C Eshi1 no longer exists because it has been removed +--------------------+| Database           |+--------------------+| information_schema | | Ceshi              | | mysql              | | performance_schema |+--------- -----------+4 rows in Set (0.00 sec)