List:General Discussion« Previous MessageNext Message »
From:Tauren Mills Date:April 8 1999 10:49am
Subject:What's up with this?
View as plain text  
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>




Thread
What's up with this?Tauren Mills8 Apr
  • RE: What's up with this?Paschal Nee8 Apr
  • Re: What's up with this?Paul DuBois8 Apr