【MySQL 11】注释
程序员文章站
2022-05-16 09:17:48
...
对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 | * | | 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 | * | | 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 | * | | 3 | Bobe | male | 25 | ximan || 4 | Kity | fama | 20 | beijing | +----+------+------+------+-----------+
以上就是 【MySQL 11】注释的内容,更多相关内容请关注PHP中文网(www.php.cn)!
推荐阅读
-
启动mysql的时候,报错pid的解决办法
-
mysql触发器语法和实例总结
-
MySQL统计数据库表中是否有自增长列_MySQL
-
php 连接mysql乱码解决方法_PHP教程
-
mysql环形同步(多主多从)_MySQL
-
MYSQL导入数据Got a packet bigger than...错误_MySQL
-
centos解决mysql连接错误ERROR 1045(28000)_MySQL
-
Oracle 11g 缺省密码期限问题
-
MySQL5.7+版本,提示mysql1055错误,sql_mode=only_full_group_by问题解决办法
-
wordpress获取自定义字段get_post_meta函数_MySQL