【MySQL 11】注释-CSDN博客

本文链接：https://blog.csdn.net/kevinelstri/article/details/52422698

对mysql代码进行阅读的时候，发现需要添加注释：

mysql注释符有三种：

1、#…
2、”- - …”
3、/…/

依次测试：

1、#…

mysql> select * from person;    #chazhao
+----+------+------+------+-----------+
| id | name | sex  | age  | addr      |
+----+------+------+------+-----------+
|  1 | Jone | fema |   27 | xianggang |
|  2 | Lily | fema |   25 | taiwan    |
|  3 | Bobe | male |   25 | ximan     |
|  4 | Kity | fama |   20 | beijing   |
+----+------+------+------+-----------+

2、”- - …”

mysql> select * from person;    --chazhao
+----+------+------+------+-----------+
| id | name | sex  | age  | addr      |
+----+------+------+------+-----------+
|  1 | Jone | fema |   27 | xianggang |
|  2 | Lily | fema |   25 | taiwan    |
|  3 | Bobe | male |   25 | ximan     |
|  4 | Kity | fama |   20 | beijing   |
+----+------+------+------+-----------+

3、/…/

mysql> select */*chazhoa*/ from person; --chazhao
+----+------+------+------+-----------+
| id | name | sex  | age  | addr      |
+----+------+------+------+-----------+
|  1 | Jone | fema |   27 | xianggang |
|  2 | Lily | fema |   25 | taiwan    |
|  3 | Bobe | male |   25 | ximan     |
|  4 | Kity | fama |   20 | beijing   |
+----+------+------+------+-----------+