mysql默认的语句定界符为;,即:
mysql> select user, host from mysql.user;
+-------+-----------+
| user | host |
+-------+-----------+
| root | 127.0.0.1 |
| root | ::1 |
| berry | localhost |
| root | localhost |
+-------+-----------+
4 rows in set (0.00 sec)
可以使用delimiter来指定语句定界符
mysql> delimiter // --指定//为语句定界符
mysql> select user, host from mysql.user;
-> //
+-------+-----------+
| user | host |
+-------+-----------+
| root | 127.0.0.1 |
| root | ::1 |
| berry | localhost |
| root | localhost |
+-------+-----------+
4 rows in set (0.00 sec)
mysql> delimiter ; //恢复到默认的语句定界符
mysql> select user, host from mysql.user;
+-------+-----------+
| user | host |
+-------+-----------+
| root | 127.0.0.1 |
| root | ::1 |
| berry | localhost |
| root | localhost |
+-------+-----------+
4 rows in set (0.00 sec)
本文介绍了MySQL中语句定界符的默认设置及其更改方法。默认情况下,MySQL使用分号(;)作为语句结束标志,并可通过'delimiter'命令自定义其他字符作为定界符。

被折叠的 条评论
为什么被折叠?



