MySQL 1292 error: Warning 1292 truncated incorrect DOUBLE value:

Problem: A large number of warning occur when executing the following statement 1292

mysql> UPDATE show_info INNER JOIN show_like on show_like.show_id = show_info.show_id SET show_info.status = 0 WHERE sh ow_like.show_id = 1 and show_like.cid = ' taobao_mecity ';

Query OK, 0 rows affected, Warnings (0.00 sec)

Rows matched:0 changed:0 warnings:0

Mysql> Show warnings;

+---------+------+-----------------------------------------------------------------------+

| Level | Code | Message |

+---------+------+-----------------------------------------------------------------------+

| Warning | 1292 | Truncated incorrect DOUBLE value: ' 25a3c516a4c15eda917963e48a254 ' |

| Warning | 1292 | Truncated incorrect DOUBLE value: ' fd3de128303ed731e2e3dda447908 ' |

| Warning | 1292 | Truncated incorrect DOUBLE value: ' B1f7f42f3e184812b5dff70fb3a35 ' |

| Warning | 1292 | Truncated incorrect DOUBLE value: ' A4E7D5114B0F79987720DE910FCF3 ' |

| Warning | 1292 | Truncated incorrect DOUBLE value: ' 0b19c482a49346eaedde3309e43a9 ' |

| Warning | 1292 | Truncated incorrect DOUBLE value: ' 284f24a76fb532ad60612580b30b2 ' |

| Warning | 1292 | Truncated incorrect DOUBLE value: ' Ffbee81cd49dc9925fa269acd9eff ' |

Solve:

Desc Show_like found that show_id is a string. Change show_id = 1 in sql to show_id = ' 1 '.