单行注释用"#"
mysql> select null * 1 as res; # null做运算为null
+------+
| res |
+------+
| NULL |
+------+
1 row in set (0.00 sec)
单行注释还可以用 "-- "
注意这种方式下"–【空格】",也就是说“--
" 与注释
之间是有空格的。
mysql> select 3 *2 res; -- 别名as关键字可以省略
+-----+
| res |
+-----+
| 6 |
+-----+
1 row in set (0.00 sec)
多行注释用"/*…*/"
mysql> select user(); /* select user(); 查看当前用户 */
+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)
mysql> select 1 + /* this is a comment
/*> a new line. */ 100;
+----------+
| 1 + 100 |
+----------+
| 101 |
+----------+
1 row in set (0.00 sec)