在服务器上传存储过程时收到错误 [英] getting error when uploading stored procedure in server
问题描述
我在服务器上传存储过程时出现此错误
错误
SQL查询:文档
CREATE PROCEDURE`sp_fetch_keyinformation_type_null`(intCoID int)BEGIN SELECT *
FROM keyinformation
WHERE TYPE IS NULL
AND CompanyID = intCoID;
MySQL说:文档
#1064 - 您的SQL语法有错误;请查看手册对应你的MySQL服务器版本,在第3行附近使用正确的语法
请帮帮我...
创建程序sp_fetch_keyinformation_type_null(IN intCoID int)
BEGIN
从keyInformation中选择*,其中TYPE为NOT NULL且CompanyID = intCoID
END
类型为非NULL,因为不存在条件为NULL和Compa的任何数据nyID = intCoID因为它总是返回0行。
希望这应该有效。
i get this error when uploading stored procedure in server
"Error
SQL query: Documentation
CREATE PROCEDURE `sp_fetch_keyinformation_type_null` ( intCoID int ) BEGIN SELECT *
FROM keyinformation
WHERE TYPE IS NULL
AND CompanyID = intCoID;
MySQL said: Documentation
#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 '' at line 3 "
please help me out...
Try this,
CREATE PROCEDURE sp_fetch_keyinformation_type_null(IN intCoID int)
BEGIN
Select * from keyinformation where TYPE is NOT NULL and CompanyID=intCoID
END
Type is NOT NULL, because there don't exists any data with condition "NULL and CompanyID=intCoID" as it always returns 0 rows.
Hope this should work.
这篇关于在服务器上传存储过程时收到错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!