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