且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

访问多列Mysql存储过程

更新时间:2023-02-02 23:12:14

最可能的原因是存储过程中的col参数长度太小.因此,请尝试在过程定义中增加该参数的长度.
The likeliest reason is that the col parameter in your stored procedure is too small in length. So try increasing the length of that parameter in your procedure definition.


检查您的@col数据类型.我认为您在varchar(20)中使用的字符较少.
但是您输入的内容超过20个.
``国家/地区,IPRStart,IPREnd''= 23个字符
因此,您的输入会变小,因此需要先输入20个字符.
试试这个varchar(max);或一些大值,例如100
Check your @col data type. I think you have used less character in varchar(20).
But you input is hvaing more than 20 chracter.
''country,IPRStart,IPREnd'' = 23 character
So your input is get shrink so it is taking first 20 chracter.
Try this varchar(max); or some big value like 100