错误代码：1064您的SQL语法有错误;检查与您的MySQL服务器版本对应的手册，以便在p_EnquiryID int附近使用正确的语法，在p_Date datetime，... [英] Error Code : 1064 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 'in p_EnquiryID int, in p_Date datetime,...

问题描述

DELIMITER $$

CREATE PROCEDURE `cms`.`SetRegistration`()
 
 
     
	in p_EnquiryID int,
	in p_Date datetime,
	in p_ProjectTopic varchar(100),
	in p_Staff varchar(30),
	in p_TotalFess int,
	in p_Fees int,
	In p_Description varchar(250),
	in p_IsActive boolean,
	in p_BranchStatus int
		
    BEGIN

		INSERT INTO tblregistration(Enquiry_ID,Date,ProjectTopic,Staff,Fees_ID,Description,Status,BatchStatus)
		values(p_EnquiryID,p_Date,p_ProjectTopic,p_Staff,p_TotalFess,p_Fees,p_Description,p_IsActive,p_BranchStatus);

    END$$


DELIMITER $$

推荐答案

CREATE PROCEDURE `cms` .SetRegistration`（）



p_EnquiryID int ，
in p_Date datetime ，
p_ProjectTopic varchar （ 100 ），
p_Staff varchar （ 30 ），
p_TotalFess < span class =code-keyword> int ，
in p_Fees int ，
在 p_Description varchar （ 250 ），
in p_IsActive boolean，
in p_BranchStatus int

BEGIN

< span class =code-keyword> INSERT INTO tblregistration（Enquiry_ID，日期，ProjectTopic ，Staff，Fees_ID，Description，Status，BatchStatus）
values （p_EnquiryID，p_Date，p_ProjectTopic，p_Staff，p_TotalFess，p_Fees，p_Description，p_IsActive，p_BranchStatus）;

END

CREATE PROCEDURE `cms`.`SetRegistration`() in p_EnquiryID int, in p_Date datetime, in p_ProjectTopic varchar(100), in p_Staff varchar(30), in p_TotalFess int, in p_Fees int, In p_Description varchar(250), in p_IsActive boolean, in p_BranchStatus int BEGIN INSERT INTO tblregistration(Enquiry_ID,Date,ProjectTopic,Staff,Fees_ID,Description,Status,BatchStatus) values(p_EnquiryID,p_Date,p_ProjectTopic,p_Staff,p_TotalFess,p_Fees,p_Description,p_IsActive,p_BranchStatus); END

DELIMITER

DELIMITER

这篇关于错误代码：1064您的SQL语法有错误;检查与您的MySQL服务器版本对应的手册，以便在p_EnquiryID int附近使用正确的语法，在p_Date datetime，...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！