MD5 - MySQL

[scamout]

I need to take a single-field table in a MySQL database and MD5 hash it into another single-field table. I don't want to lose the plain text table either.

It would seem to me that there'd be a fairly simple query line to do this in MySQLAdmin but I'll be dipped if I can get it right. I'm fairly inept at this sort of thing, being at the level where I can look at code and get an idea what it does and then maybe modify it for my own use.

I've tried all sorts of variations of

INSERT INTO MD5table (hashed) VALUES md5(PlainTable (nothashed));

but always end up getting a message telling me there's an error near the md5.

This shouldn't be difficult, should it?

[HardCoded]

Which version of MySQL do you use?
MD5() was added in MySQL 3.23.2

However, your syntax is wrong.
Try:

INSERT INTO MD5table SELECT MD5(nothashed) FROM PlainTable;

I'm assuming nothashed is the name of the field in PlainTable. If not, adjust as required.

[scamout]

Version 4.3.4

Thanks - I'll give that a try!

[scamout]

Looks like that did it. THANK YOU!!!