注释:
以/**注释内容**/
mysql> /**列出所有的数据库**/ show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db_springcloud |
| mysql |
| performance_schema |
| test |
| wordpress |
| xinyu |
| xinyu2 |
| zabbix |
+--------------------+
9 rows in set (0.00 sec)
###注释是从‘#’字符到行尾
mysql> #这里是注释,到行尾都是注释,所以后面的命令不执行 showdatabases;
mysql>
如果遇到很长的sql语句的话,在控制台为了阅读方便,我们可以使用\,使之继续输入;
mysql> show \
-> databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db_springcloud |
| mysql |
| performance_schema |
| test |
| wordpress |
| xinyu |
| xinyu2 |
| zabbix