Hi.

mysql> describe unions_data;
+-------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+----------------+
| ID | int(11) | NO | PRI | NULL | auto_increment |
| Title | varchar(70) | NO | | NULL | |
| Description | text | YES | | NULL | |
| UsersID | int(11) | NO | MUL | NULL | |
+-------------+-------------+------+-----+---------+----------------+
4 rows in set (0.02 sec)

mysql> select * from unions_data;
+----+-----------+-------------+---------+
| ID | Title | Description | UsersID |
+----+-----------+-------------+---------+
| 4 | Union One | descr one | 2 |
| 5 | Union Two | descr two | 2 |
+----+-----------+-------------+---------+
2 rows in set (0.00 sec)

mysql> update unions_data set Title='Dos' and Description='dos' where ID=5;
ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'Dos'
mysql> update unions_data set Title=2.2 and Description='dos' where ID=5;
Query OK, 1 row affected (0.33 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from unions_data;
+----+-----------+-------------+---------+
| ID | Title | Description | UsersID |
+----+-----------+-------------+---------+
| 4 | Union One | descr one | 2 |
| 5 | 0 | descr two | 2 |
+----+-----------+-------------+---------+
2 rows in set (0.00 sec)

Notice that it threw an error about an incorrect DOUBLE value for a
field that is a varchar. Notice that when it did decide to update, it
updated incorrectly and it updated Title but _not_ Description, yet
issued no Warnings. Am I missing something??
TIA,
Savi

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql