mysql基础1-数据库安装配置及语句规范

一、思维脑图

1.登录、退出mysql

登录

C:\windows\system32>mysql -uroot -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.5.27 MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement

2.修改命令提示符

C:\windows\system32>mysql -uroot -p --prompt=king
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.5.27 MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
# 通过命令修改
kingprompt \u
PROMPT set to '\u'
rootprompt \h
PROMPT set to '\h'
localhostprompt \h~\u~\D~\d
PROMPT set to '\h~\u~\D~\d'
localhost~root~Mon Jul 06 18:42:45 2020~(none)prompt mysql>
PROMPT set to 'mysql>'
mysql>

3.MYSQL常用命令

mysql>SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 5.5.27    |
+-----------+
1 row in set (0.00 sec)

mysql>select now();
+---------------------+
| now()               |
+---------------------+
| 2020-07-06 18:50:43 |
+---------------------+
1 row in set (0.00 sec)

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

4.MYSQL 语句规范

#折行操作
mysql>SELECT
    ->
    -> NOW()
    -> ;
+---------------------+
| NOW()               |
+---------------------+
| 2020-07-06 18:53:16 |
+---------------------+
1 row in set (0.00 sec)

#引号成对出现
mysql>SELECT NOW()'
    '> ;
    '> ';
+---------------------+
| ;
                  |
+---------------------+
| 2020-07-06 18:56:50 |
+---------------------+
1 row in set, 1 warning (0.00 sec)

5，补充

1）\c的作用

作用：取消当前输入，当前输入不会执行

mysql>SELECT NOW()\c
mysql>

2)修改默认的命令分隔符

mysql>DELIMITER //
mysql>SELECT NOW();
    -> //
+---------------------+
| NOW()               |
+---------------------+
| 2020-07-06 19:02:47 |
+---------------------+
1 row in set (0.00 sec)

C:\windows\system32>mysql -uroot -p --delimiter=//
Enter password: ******

3）上下键调用之前已输入命令

4）开启输出日志

mysql> \T D:\MYSQL\MYSQLDEMO\mysql1.txt
Logging to file 'D:\MYSQL\MYSQLDEMO\mysql1.txt'
mysql> SELECT NOW();
    -> //
+---------------------+
| NOW()               |
+---------------------+
| 2020-07-06 19:15:11 |
+---------------------+
1 row in set (0.00 sec)

mysql> DELIMITER ;
mysql> \t  # 退出日志
Outfile disabled.