mysql语句定界符[delimiter]

来源：互联网发布：电影知乎编辑：程序博客网时间：2024/06/01 10:38

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)

阅读全文

0 0