Re: Fedora 5 and eventum/mysql question

Wed, 28 Feb 2007 10:48:22 -0800 

On Wed, Feb 28, 2007 at 10:19:59AM -0800, maverick wrote:
> The UPDATE was wrong but now I have a new problem.  It appears the
> command is not doing anything.
> 
> mysql> UPDATE eventum_user SET usr_password=MD5('123456') WHERE
>      > usr_email='valener (AT) nortghrum (DOT) com';
> Query OK, 0 rows affected (0.00 sec)
> Rows matched: 0  Changed: 0  Warnings: 0

Based on the zero count for rows matched, I'm going to guess that user
e-mail address doesn't exist in the table.  Is it really formatted like
that in the table?  Does "SELECT * FROM eventum_user WHERE usr_email
LIKE 'valener%'" return anything?

-- 
Chris Grau

Attachment: pgpZso5HB1852.pgp
Description: PGP signature

-- 
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list

Reply via email to