MySQL-[--001--]-报错（ (1292, u"Truncated incorrect DOUBLE value: '424a000000066'") result = self._query(query)）

 

1.数据库sql语句：SELECT seat_id FROM netsale_order_seat os join netsale_order nor on os.order_code=nor.order_code WHERE pay_order_no=${order_id[0]};

　　报错信息：(1292, u"Truncated incorrect DOUBLE value: '424a000000066 '")result = self._query(query)

 

　　解决方法：将SELECT seat_id FROM netsale_order_seat os join netsale_order nor on os.order_code=nor.order_code WHERE pay_order_no=${order_id[0]};中的pay_order_no=${order_id[0]}改成pay_order_no=‘${order_id[0]}’;