Mysql储存过程1: 设置结束符与储存过程创建

mysql> use test$
Database changed
mysql> create procedure myshow()
    ->   begin
    ->     select user(),database();
    ->   end$
Query OK, 0 rows affected (0.03 sec)

mysql> call myshow
    -> $
+----------------+------------+
| user()         | database() |
+----------------+------------+
| root@localhost | test       |
+----------------+------------+
1 row in set (0.02 sec)

Query OK, 0 rows affected (0.03 sec)

mysql> myshow()$
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ‘myshow()‘ at line 1
mysql> call myshow()$
+----------------+------------+
| user()         | database() |
+----------------+------------+
| root@localhost | test       |
+----------------+------------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

mysql>

Mysql储存过程1: 设置结束符与储存过程创建

标签：syn   style   括号   erro   res   code   version   row   check