Question

mysql已经创建了一个存储过程，要修改，但是语句有错，不知道哪里错了

DELIMITER $$

ALTER
PROCEDURE `wenxionline`.`sp_student`()
BEGIN
DECLARE StuNo CHAR(4);
DECLARE StuName VARCHAR(20);
DECLARE Age INT;
DECLARE Sex BOOL;

SELECT * FROM students;
END$$

DELIMITER ;

Answer 1

ALTER PROCEDURE proc_name [characteristic ...]

characteristic:
{ CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
| SQL SECURITY { DEFINER | INVOKER }
| COMMENT 'string'

This statement can be used to change the characteristics of a stored procedure. More than one change may be specified in an ALTER PROCEDURE statement. However, you cannot change the parameters or body of a stored procedure using this statement; to make such changes, you must drop and re-create the procedure using DROP PROCEDURE and CREATE PROCEDURE.
就是说只能改名字和定义不能改里面的内容。要删了重新建。

Answer 2

ALTER PROCEDURE `wenxionline`.`sp_student`()
AS
......试一试