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
Enter your message below
Sign in or Join us (it's free).