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
