Update geht nicht

[Matthias Jaekle <matthias_(at)_jaekle.net>]

Hallo,

irgendwie klappen bei mir neuerdings die updates nicht mehr. Hat mir
jemand ein Tip was ich in folgendem Beispiel falsch mache ? 
Eigentlich sollten aus den -99 -1002 werden.
Einsetzen tu ich mysql 3.23.22-beta unter Suse 6.4

Besten Dank
Tschuess

Matthias Jaekle

mysql> select adresse, level, found from links where id=13065795 and
found=-99 and level<4;
+-------------------------------------------------------------+-------+-------+
| adresse                                                     | level |
found |
+-------------------------------------------------------------+-------+-------+
| http://shopping.altavista.de/av/search/browse?cat=1062&pg=4 |   003
|   -99 |
+-------------------------------------------------------------+-------+-------+
1 row in set (0.00 sec)

mysql> update links set found=-1002 where adresse like
'http://shopping%';
Query OK, 0 rows affected (4.06 sec)
Rows matched: 37161  Changed: 0  Warnings: 0

mysql> select adresse, level, found from links where id=13065795 and
found=-99 and level<4;
+-------------------------------------------------------------+-------+-------+
| adresse                                                     | level |
found |
+-------------------------------------------------------------+-------+-------+
| http://shopping.altavista.de/av/search/browse?cat=1062&pg=4 |   003
|   -99 |
+-------------------------------------------------------------+-------+-------+
1 row in set (0.00 sec)

mysql> describe links;
+------------+------------------------------+------+-----+---------+----------------+---------------------------------+
| Field      | Type                         | Null | Key | Default |
Extra          | Privileges                      |
+------------+------------------------------+------+-----+---------+----------------+---------------------------------+
| id         | bigint(20) unsigned          |      | PRI | NULL    |
auto_increment | select,insert,update,references |
| adresse    | tinytext                     |      | MUL |        
|                | select,insert,update,references |
| level      | tinyint(3) unsigned zerofill | YES  |     | NULL   
|                | select,insert,update,references |
| found      | smallint(5)                  |      |     | 0      
|                | select,insert,update,references |
| father     | bigint(20) unsigned          |      |     | 0      
|                | select,insert,update,references |
| source     | tinytext                     |      |     |        
|                | select,insert,update,references |
| insertdate | timestamp(8)                 | YES  |     | NULL   
|                | select,insert,update,references |
| good       | smallint(6)                  | YES  |     | NULL   
|                | select,insert,update,references |
+------------+------------------------------+------+-----+---------+----------------+---------------------------------+
8 rows in set (0.04 sec)

mysql>

---
*** Abmelden von dieser Mailingliste funktioniert per E-Mail
*** an mysql-de-request_(at)_lists.4t2.com mit Betreff/Subject: unsubscribe