Question on changing an item

satimis · #1 (**permalink**) 05-15-09, 12:39

Hi folks,

Ran following entry creating a database;

Code:

mysql> INSERT INTO users (id,name,maildir,clear) VALUES
    -> ('xyz@aaa.com','xyz','xyz/', encrypt('password') ),
    -> etc.
    -> etc.
    -> etc.;
Query OK, 4 rows affected (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 0

Now I need changing "clear" to "crypt"

Please advise how to make such a change. TIA

B.R.
satimis

r937 · #2 (**permalink**) 05-15-09, 18:06

best advice ever -- read da manual MySQL :: MySQL 5.1 Reference Manual :: 12.1.7 ALTER TABLE Syntax

satimis · #3 (**permalink**) 05-15-09, 20:01

Quote:

Originally Posted by r937

best advice ever -- read da manual MySQL :: MySQL 5.1 Reference Manual :: 12.1.7 ALTER TABLE Syntax

Hi,

Thanks for your URL.

In my case I suppose using CHANGE on following command;

Code:

mysql> CHANGE 'clear' 'crypt' VALUE;

VALUE is column_definition.

Please correct me if I'm wrong. TIA

B.R.
satimis

r937 · #4 (**permalink**) 05-15-09, 20:13

Quote:

Originally Posted by satimis

Please correct me if I'm wrong.

sorry, i cannot, because now i really don't understand what you're doing

satimis · #5 (**permalink**) 05-15-09, 20:25

Quote:

Originally Posted by r937

sorry, i cannot, because now i really don't understand what you're doing

Hi r937,

What I expect to do is changing the name "clear" to "encryt" on that column running;

mysql> USE maildb;

mysql> CHANGE 'clear' 'crypt' VALUE;

Thanks

B.R.
satimis