MySQL 命令行代码学习

mysql> prompt \h
PROMPT set to '\h'
localhost prompt \u@\h \d>
PROMPT set to 'prompt \u@\h \d>'
prompt root@localhost (none)>prompt \u@\h \d
PROMPT set to '\u@\h \d'
root@localhost (none) SELECT VERSION();
+------------+
| VERSION() |
+------------+
| 5.7.17-log |
+------------+
1 row in set (0.00 sec)

root@localhost (none)SELECT NOW();
+---------------------+
| NOW() |
+---------------------+
| 2017-03-21 19:46:40 |
+---------------------+
1 row in set (0.00 sec)

root@localhost (none)SELECT USER();
+----------------+
| USER() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

root@localhost (none)CREATE DATABASE t1;
ERROR 1007 (HY000): Can't create database 't1'; database exists
root@localhost (none)CREATE DATABASE IF NOT EXISTS t1;
Query OK, 1 row affected, 1 warning (0.00 sec)

root@localhost (none)SHOW WARNINGS;
+-------+------+---------------------------------------------+
| Level | Code | Message |
+-------+------+---------------------------------------------+
| Note | 1007 | Can't create database 't1'; database exists |
+-------+------+---------------------------------------------+
1 row in set (0.00 sec)

root@localhost (none)SHOW DATABASES
-> ;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| sys |
| t1 |
| t2 |
| world |
+--------------------+
8 rows in set (0.03 sec)