mysql基础语句
show命令
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)
创建数据库
mysql> create database `ha-test`;
Query OK, 1 row affected (0.01 sec)
查看数据库具体位置
mysql> select database();
+------------+
| database() |
+------------+
| ha-test |
+------------+
在终端查看数据库
# mysqlshow -uroot -p123456
Warning: Using a password on the command line interface can be insecure.
+--------------------+
| Databases |
+--------------------+
| information_schema |
| ha-test |
| mysql |
| performance_schema |
+--------------------+
# mysql -e 'show databases' -uroot -p123456
Warning: Using a password on the command line interface can be insecure.
+--------------------+
| Database |
+--------------------+
| information_schema |
| ha-test |
| mysql |
| performance_schema |
+--------------------+
查看时间
mysql> select now(),user(),database();
+---------------------+----------------+------------+
| now() | user() | database() |
+---------------------+----------------+------------+
| 2017-06-26 20:50:51 | root@localhost | ha-test |
+---------------------+----------------+------------+
1 row in set (0.00 sec)
删除数据库
mysql> drop database `ha-test`;
Query OK, 0 rows affected (0.00 sec)
mysql> select now(),user(),database();
+---------------------+----------------+------------+
| now() | user() | database() |
+---------------------+----------------+------------+
| 2017-06-26 20:55:46 | root@localhost | NULL |
+---------------------+----------------+------------+
1 row in set (0.00 sec)
