Database-mysql Common Operations

One: Database query increased Delete

1) MySQL database query:show Databases

MariaDB [mysql]> show databases; +--------------------+| Database           |+--------------------+| information_schema | | mysql              | | performance_schema | | Test                in Set (0.00 sec)

2) Database creation: Create databasestest2 charset UTF8;

Note: CharSet UTF8 can support Chinese

MariaDB [mysql]>1 Row Affected (0.00 sec)

3) Database deletion:drop db test2　

MariaDB [mysql]> drop database test2; Query OK, 0 rows affected (0.00 sec)

　　

Database-mysql Common Operations