Adam

Recent Blog Comments By Adam

• Data Truncation: Truncated Incorrect DOUBLE Value When Updating Timestamp

  Posted on Apr 16, 2010 at 10:31 PM

  Similar issue: appear to have a problem with a double, but that is not the cause.... create table test (col1 varchar(10), col2 varchar(10), col3 double); insert into test values ("a","b",0); update test set col3=1.2 where col1+col2="a"+"b"; Query OK, 1 row affected, 2 warnings (0.00 sec) Rows mat... read more »