I am not able to update the contents of my table. Below is a list of commands and their results so that you can see what exactly I am doing. Any ideas whay I can't upadate it?

Thank you very much


mysql> create table sample_table(
-> id int not null auto_increment primary key,
-> testtext text,
-> testdate date not null
-> );

Query OK, 0 rows affected (0.00 sec)




mysql> describe sample_table;
+----------+---------+------+-----+------------+----------------+---------------------------------+
| Field | Type | Null | Key | Default | Extra | Privileges |
+----------+---------+------+-----+------------+----------------+---------------------------------+
| id | int(11) | | PRI | NULL | auto_increment | select,insert,update,references |
| testtext | text | YES | | NULL | | select,insert,update,references |
| testdate | date | | | 0000-00-00 | | select,insert,update,references |
+----------+---------+------+-----+------------+----------------+---------------------------------+
3 rows in set (0.00 sec)





mysql> select id, testtext, testdate from sample_table;
+----+-------------------+------------+
| id | testtext | testdate |
+----+-------------------+------------+
| 1 | text to test it | 2000-08-02 |
| 2 | number2 test text | 2000-02-22 |
+----+-------------------+------------+
2 rows in set (0.00 sec)




mysql> update sample_table set testtext="new text", testdate="2000-07-07" where id=1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0




mysql> select id, testtext, testdate from sample_table;
+----+-------------------+------------+
| id | testtext | testdate |
+----+-------------------+------------+
| 1 | text to test it | 2000-08-02 |
| 2 | number2 test text | 2000-02-22 |
+----+-------------------+------------+
2 rows in set (0.00 sec)