任何身体可以帮助解决手术问题吗？ [英] Can any body help for procedure problem?

问题描述

我在mysql中编写了一个程序，但是我可以运行它！

i wrote a procedure in mysql but i coulnd run it!

CREATE PROCEDURE Insert_Info(IN Name1 varchar(30),IN Fname1 varchar(30))
BEGIN
INSERT INTO info(Name,Fname)VALUES(Name1,Fname1)
END

我尝试了什么：



i出现此错误：



处理您的请求时发生了一个或多个错误：



以下查询失败：CREATE PROCEDURE`Insert_Info`（）NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER CREATE PROCEDURE Insert_Info（IN Name1 varchar（30），IN Fname1 varchar（30））BEGIN INSERT INTO info（Name，Fname）VALUES（Name1，Fname1）END



MySQL说：＃1303 - 无法在另一个存储的例程中创建一个过程

What I have tried:

i got this error :

One or more errors have occurred while processing your request:

The following query has failed: "CREATE PROCEDURE `Insert_Info`() NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER CREATE PROCEDURE Insert_Info(IN Name1 varchar(30),IN Fname1 varchar(30)) BEGIN INSERT INTO info(Name,Fname)VALUES(Name1,Fname1) END"

MySQL said: #1303 - Can't create a PROCEDURE from within another stored routine

推荐答案

Quote：

CREATE PROCEDURE`Insert_Info`（）NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER

CREATE PROCEDURE Insert_Info

CREATE PROCEDURE `Insert_Info`() NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER
CREATE PROCEDURE Insert_Info

你有 CREATE PROCEDURE 两次。您正在尝试创建一个创建过程的过程，这是不允许的。



更正命令的语法：

MySQL :: MySQL 5.7参考手册:: 14.1.16 CREATE PROCEDURE和CREATE FUNCTION语法 [ ^ ]

You've got CREATE PROCEDURE twice. You're trying to create a procedure which creates a procedure, and that isn't allowed.

Correct the syntax of your command:
MySQL :: MySQL 5.7 Reference Manual :: 14.1.16 CREATE PROCEDURE and CREATE FUNCTION Syntax[^]

CREATE PROCEDURE `Insert_Info`(IN Name1 varchar(30),IN Fname1 varchar(30)) 
NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER 
BEGIN 
    INSERT INTO info(Name,Fname)
    VALUES(Name1,Fname1)
END

这篇关于任何身体可以帮助解决手术问题吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！