sqlalchemy操作数据时报错:
Warning: (1292, "Truncated incorrect DOUBLE value: 'weixincode'")
result = self._query(query)
但是数据却插入了,原因是什么呢?
源码如下:
@staticmethod
def create_account(area_code, game_id, account, image_id, nickname, imei, imsi, client_version, phone_type):
""" 生成账号 """
new_data = {
'area_code': area_code,
'game_id': game_id,
'account': account,
'image_id': image_id,
'nickname': nickname,
'imei': imei,
'imsi': imsi,
'client_version': client_version,
'account_status': 1,
'phone_type': phone_type,
}
new_data_obj = UserAccount(**new_data)
mysql_db['game_userinfo'].add(new_data_obj)
mysql_db['game_userinfo'].commit()
return
精度问题,mysql做了精度调整