sqlalchemy operation data Times error:
Warning: (1292, "Truncated incorrect DOUBLE value: "weixincode"")
result = self._query(query)
but the data is inserted. Why?
the source code is as follows:
@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