Everything enters as a 0

  • 18 years ago

    Hi!  I have MySQL database v3.23.49-nt on Windows XP.  When I enter the following code into the database the value becomes "0" no matter what I typed in the database (fields marked in [] brackets is data that I wish not to reveal).  This is what my screen looks like:


    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 11 to server version: 3.23.49-nt


    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


    mysql> use [database];
    Database changed
    mysql> UPDATE Users SET Verified="1" AND Password="this is the password" WHERE Email="my email address";
    Query OK, 0 rows affected (0.01 sec)
    Rows matched: 1  Changed: 0  Warnings: 0


    mysql> select Email, Verified, Password FROM Users;
    +-----------------------+----------+-----------+
    | Email                     | Verified | Password |
    +-----------------------+----------+-----------+
    | my email addresss  |           0 | 0            |
    +-----------------------+----------+-----------+
    1 row in set (0.01 sec)


    mysql>


    Can you please help me!!!!!!!!!!!!!!!!!!!!!!!!!
    Thanks, AP

  • 18 years ago

    maybe


    Code:
    UPDATE Users SET Verified="1", Password="this is the password" WHERE Email="my email address";

  • 18 years ago

    Thank you so much, Teft!!!!!!!


    I love you!


    AP

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“The trouble with programmers is that you can never tell what a programmer is doing until it's too late.” - Seymour Cray