Re: encrypting a column

["Rolf Hopkins" <rhopkins@xxxxxxxxxxxxxxxxxxx>]

I think what you may be looking for is something like

CREATE TABLE .... SELECT FROM

Look up the manual on this.

----- Original Message -----
From: <david@xxxxxxxxxxxx>
To: <mysql@xxxxxxxxxxxxxxx>
Sent: Sunday, March 04, 2001 12:11
Subject: encrypting a column


> I have a column in my maildb table that I need to encrypt using the
Password
> feature.  The users and the passwords are stored in another table in the
> database, I would like to just rip them out of the non-encrypted fields
> (radcheck.UserName, and radcheck.Value) and place them into the
> maildb.Username, and (encrypted) into maildb.passwd.  I have a text file
> that contains the user and passes but I have had no success in getting a
> bash script to work either.
> Any suggestions would be appreciated.
>
> David
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread67334@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail
<mysql-unsubscribe-rhopkins=mail.waytech.com.tw@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread67405@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php