> Is it possible to update all my encoded data with another password?
Yes. Example for the encoded/decode functions:
UPDATE table
SET pass_colum = encode(decode(pass_column, old_password), new_password);
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsu
On Friday 04 February 2005 03:31 pm, John Trammell wrote:
> In my version of MySQL (4.1.9), your sample code generates an error:
>
> mysql> select decode(encode("foo"));
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for
---+
| foo |
+---+
1 row in set (0.00 sec)
> -Original Message-
> From: Jeff Smelser [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 04, 2005 2:14 PM
> To: mysql@lists.mysql.com
> Subject: Re: ENCODE & D
On Friday 04 February 2005 11:00 am, shaun thornburgh wrote:
> Apparently not!
>
> mysql> SELECT DECODE ( CSV_DATA_ENC_FORENAME, "test_password" ) FROM
> DATA_TABLE_PID_1_DESC_137;
Is it so hard to read directions?
select decode(csv_data_enc_forename) from DATA_TABLE_PID_1_DESC_137;
This assumes
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 '(
> CSV_DATA_ENC_FORENAME, "test_password" ) FROM DATA_TABLE_PID_
> mysql>
>
> Any ideas?
>
>>From: Jeff Sm
_DATA_ENC_FORENAME, "test_password" ) FROM DATA_TABLE_PID_
mysql>
Any ideas?
From: Jeff Smelser <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: Re: ENCODE & DECODE
Date: Fri, 4 Feb 2005 10:20:14 -0600
On Friday 04 February 2005 09:51 am, shaun thornburgh wrote:
> I have a table
On Friday 04 February 2005 09:51 am, shaun thornburgh wrote:
> I have a table where users upload various data items via a web site. Some
> fields in the table are named DATA_ENC... to denote that the data should be
> encrypted uusing the encode function. This all works fine, however when I
> come
