ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'asfsda1'

最新推荐文章于 2023-12-12 12:48:08 发布

weixin_33924312

最新推荐文章于 2023-12-12 12:48:08 发布

阅读量127

点赞数

原文链接：http://www.cnblogs.com/elontian/p/9134789.html

版权

mysql> UPDATE financial_sales_order SET ASSIGN_TIME = '2018-05-02 00:00:00' where CUSTOMER_ID=3541535;
ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'asfsda1'
mysql> desc financial_sales_order;
+-------------------+--------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+-------------------+-----------------------------+
| CUSTOMER_ID | varchar(80) | YES | | NULL | |
+-------------------+--------------+------+-----+-------------------+-----------------------------+
29 rows in set (0.00 sec)

mysql> UPDATE financial_sales_order SET ASSIGN_TIME = '2018-05-02 00:00:00' where CUSTOMER_ID='3541535';
Query OK, 1 row affected (0.15 sec)
Rows matched: 1 Changed: 1 Warnings: 0

转载于:https://www.cnblogs.com/elontian/p/9134789.html