I encrypt a password in MySQL

inputcode='@bcde'

STORE calcSqlConnect() TO dlnConnHandle
TEXT TO dlcSQL TEXTMERGE noshow
SELECT sha1(inputcode) as myencrypt 
ENDTEXT 
STORE SQLEXEC(dlnConnHandle,dlcSql,'myresult') TO dlnSql
SQLDISCONNECT(dlnConnHandle)

How can I take out the return value from MySQL?


Thanks for the help

Jerry



>You can't reverse a hashed password, period.
>
>>Got it.
>>
>>My understanding is if I use SHA-1, and the user knows I use SHA-1, there is no way to reverse it. Is that correct?
>>
>>Jerry
>>
>>
>>
>>>>How can I encrypt a string, example I want to encrypt the password
>>>
>>>Basically, you don't. A better idea is to store the value ("digest") of the string when processed through a hash function.
>>>
>>>Overview at https://securityboulevard.com/2020/05/hashing-what-you-need-to-know-about-storing-passwords/