mysql基础1-数据库安装配置及语句规范_3. 将目标站点安装,安装时注意将数据库地址改为db,其余配置不动,全部下一步直至安-CSDN博客

本BLOG上原创文章未经本人许可，不得用于商业用途，转载请注明出处。

本文链接：https://blog.csdn.net/weixin_46649052/article/details/107168268

本文详细介绍了MySQL的登录与退出方法，如何修改命令提示符，常用的SQL命令，语句规范及一些实用技巧，如折行操作、引号使用、命令分隔符修改、上下键调用历史命令、开启日志等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

文章目录

- 一、思维脑图

一、思维脑图

在这里插入图片描述

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.