Python sqlalchemy operation mysql error, Truncated incorrect DOUBLE value?

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

accuracy problem, mysql has made precision adjustment

Menu