Try this: insert into tablename values ('myusername', password('mypassword'));
[EMAIL PROTECTED] wrote:
On Tue, Feb 04, 2003 at 02:58:28PM -0500, Jianping Zhu wrote:--
I have mysql in a redhat machine. I need to use mysql do userNot for sure on the exact syntax becuse I've always used myPhpAdmin's
authentication to a website.
I have a table like following.
+----------+----------+
| username | passwd |
+----------+----------+
| jianping | jian1830 |
| chichi | jian1830 |
+----------+----------+
I want the passwd field not to be plain text but encrypted. how can i do
that?
md5 utility but it would be something like
MD5("jian1830")
this would do an MD5 hash
Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php