Why does the delete say that 0 rows are affected, but doing a select shows
that records were affected? I'm using mysql Ver 9.31 Distrib 3.22.20a, for
pc-linux-gnu (i686)
Thanks,
Tauren
mysql> select * from base;
+----+----------+------+------+-------------+--------+-----------+----------
-----------+---------------------+---------------------+--------------------
-+---------------------+---------------------+------+
| id | site | name | type | description | author | copyright |
templateurl | date | createdate | modifydate
| activatedate | expiredate | sort |
+----+----------+------+------+-------------+--------+-----------+----------
-----------+---------------------+---------------------+--------------------
-+---------------------+---------------------+------+
| 1 | servlets | test | | | | |
/order/$/index.html | 1999-04-08 00:00:00 | 1999-04-08 03:18:31 | 1999-04-08
03:18:31 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | 1 |
| 2 | servlets | test | | | | |
/order/$/index.html | 1999-04-08 00:00:00 | 1999-04-08 03:20:22 | 1999-04-08
03:20:22 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | 1 |
| 3 | servlets | test | | | | |
/order/$/index.html | 1999-04-08 00:00:00 | 1999-04-08 03:21:22 | 1999-04-08
03:21:22 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | 1 |
| 4 | servlets | test | | | | |
/order/$/index.html | 1999-04-08 00:00:00 | 1999-04-08 03:22:16 | 1999-04-08
03:22:16 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | 1 |
+----+----------+------+------+-------------+--------+-----------+----------
-----------+---------------------+---------------------+--------------------
-+---------------------+---------------------+------+
4 rows in set (0.00 sec)
mysql> delete from base;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from base;
Empty set (0.00 sec)
mysql>
