Re: Syntax Query Help DECRYPT

[Paul DuBois]

At 1:08 PM -0600 9/19/03, Stout, Jeff wrote:
	I have added data into MySQL server 4.0.15

        INSERT INTO userdata (userid, password)
        VALUES ('user', AES_ENCRYPT ("user","password")
	I'm having trouble doing the decrypt

        SELECT userid, password (AES_DECRYPT)
        FROM userdata blah blah blah
	Something this this

        Thanks
        Jeff Stout
The syntax for both is the same:

AES_ENCRYPT(string,key_string)
AES_DECRYPT(string,key_string)
See:

http://www.mysql.com/doc/en/Miscellaneous_functions.html

Please note that internals is not for questions of this type.
I've removed it from the cc: list.
Thanks.

--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]