one for the mysql server gurus
VJ
vijay.s.gill at gmail.com
Mon Jul 25 13:54:21 UTC 2005
I am no guru, but I carried out the following test
mysql> select * from t;
+------+-------+
| c1 | c2 |
+------+-------+
| 1 | hello |
| 2 | hello |
| 3 | NULL |
| 4 | NULL |
| 5 | Helly |
| 6 | Nelly |
| 7 | Kelly |
+------+-------+
7 rows in set (0.00 sec)
mysql> update t set c2 = replace(t2,'hell', 'heaven');
ERROR 1054: Unknown column 't2' in 'field list'
mysql> update t set c2 = replace(c2,'hell', 'heaven');
Query OK, 2 rows affected (0.00 sec)
Rows matched: 7 Changed: 2 Warnings: 0
mysql> select * from t;
+------+---------+
| c1 | c2 |
+------+---------+
| 1 | heaveno |
| 2 | heaveno |
| 3 | NULL |
| 4 | NULL |
| 5 | Helly |
| 6 | Nelly |
| 7 | Kelly |
+------+---------+
7 rows in set (0.01 sec)
The update statement found 7 rows (all of the rows in my table bcos
there was no where clause, and only two rows actually got updated.
Regards from VJ
More information about the fedora-list
mailing list