如何将varchar转换为int [英] how to convert varchar to int

问题描述

嗨
我在MySql中创建了一个存储过程，并在其中调用了一个参数
在varchar中，我想将其转换为整数

我的商店流程是

创建过程abc
(
搜索varchar(10)
)
开始
从表1选择ID，名称，城市
其中id = cast(搜索为int);
结束

但是强制转换函数给出错误
浪费了演员，我也使用了convert，但是它也不起作用
convert(int，search);

请帮我...

谢谢

问候
Sagar Khairnar

解决方案

您遇到什么错误?

sagar55写道:

 创建 程序 abc
(
搜索 varchar ( 10 )
)

我认为应该是

  @ search   varchar (
 
 
hi


i have create a store procedure in MySql and in that i m calling a parameter 

which is in varchar and i want to convert it into integer



my store proceducre is 



create procedure abc

(

 search varchar(10)

)

begin

select id,name,city from table1

where id=cast(search as int);

end



but the cast function is giving error

and isnted of cast i have also used convert but it is also not working

convert(int,search);



pls help me ...



Thanks



Regards

Sagar Khairnar
解决方案
What error are you getting?





sagar55 wrote:
create procedure abc
(
search varchar(10)
)






I think it should be 
@search varchar(10)




and 
where id=cast(@search as int);

hi sir,



u have suggest the is in MsSql

but i want that in MySql



so can u give again suggest me that



regards

Sagar55

Common sense would suggest you pass an integer to your stored proc.  This would also allow you to sanitise your input in the presentation layer, instead of having an error deep in your data layer.



Please don''t push ''answer'' to ask more questions, edit your post to add detail.


                        
这篇关于如何将varchar转换为int的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！