Man this is emberesing
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
Any suggestions
Thank you
Chris Grau <[EMAIL PROTECTED]> wrote: On Wed, Feb 28, 2007 at 09:56:32AM -0800,
maverick wrote:
> Hi everyone, I'm having a MYSQL SYNTAX problem. I need to change a
> users password but I keep getting the following error; First the
> command I'm trying to use
>
> UDATE eventum_user SET usr_password=MD5('123456') WHERE
^^^^^
Is this a typo in your mail, or in the actual command you're issuing?
> usr_email='valener (AT)northgrum(DOT)com';
>
> now the error
>
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near 'UDATE eventum_user SET usr_password=MD5('123456')
> WHERE usr_email='valener (AT)n' at line 1
The error also reads 'UDATE' instead of 'UPDATE.'
> I know it's syntax because I just don't know sql and have been in the
> interenet all moring looking.
Yup, syntax typo.
> Thank you in advance.
You're welcome (assuming I'm right).
By the way, what does this have to do with Fedora 5?
--
Chris Grau
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
mav
CCNA, CCA
---------------------------------
The fish are biting.
Get more visitors on your site using Yahoo! Search Marketing.
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
