可以这么创建
DROP PROCEDURE IF EXISTS text;
CREATE PROCEDURE text()
BEGIN
#这里写过程语句
END;
比如,存储过程我需要查询一个表,可以这么写
DROP PROCEDURE IF EXISTS text;
CREATE PROCEDURE text()
BEGIN
SELECT * from users;
END;
你也可以查询多张表,如
DROP PROCEDURE IF EXISTS text;
CREATE PROCEDURE text()
BEGIN
SELECT * from table1;
SELECT * from table2;
SELECT * from table3;
END;
...