自己顶一下drop procedure if exists nz6; 这招貌似可以 替换掉alter
好像不支持alter功能的。
mysql> mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -ADatabase changed mysql> -- 修改存储过程 mysql> DELIMITER $$ mysql> DROP PROCEDURE IF EXISTS nz5$$ Query OK, 0 rows affected (0.00 sec)mysql> CREATE PROCEDURE nz5 (IN Nname VARCHAR(30),IN Aage VARCHAR(30)) -> BEGIN -> INSERT INTO ttable (Tname,Tage)VALUES (Nname,Aage); -> END $$ Query OK, 0 rows affected (0.01 sec)mysql>
好像不支持alter功能的。
mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -ADatabase changed
mysql> -- 修改存储过程
mysql> DELIMITER $$
mysql> DROP PROCEDURE IF EXISTS nz5$$
Query OK, 0 rows affected (0.00 sec)mysql> CREATE PROCEDURE nz5 (IN Nname VARCHAR(30),IN Aage VARCHAR(30))
-> BEGIN
-> INSERT INTO ttable (Tname,Tage)VALUES (Nname,Aage);
-> END $$
Query OK, 0 rows affected (0.01 sec)mysql>