【Python】使用PyMySQL向MySQL数据库中插入数据

首先给出我的实例：

connection = pymysql.connect(host=db_host_mysql,
                                 user=db_username_mysql,
                                 password=db_pass_mysql,
                                 database=db_schema_MarketData_mysql,
                                 cursorclass=pymysql.cursors.DictCursor)
    with connection:
        with connection.cursor() as cursor:
            # Create a new record
            sql = "INSERT INTO `SpotForecast_Run` (`Run_Name`, `Run_Description`, `Run_Date`, `Run_StartDate`, " \
                  "`Run_EndDate`, `ClientID`, `Version_No`, `IsPublic`, `Run_ReportLabel`) VALUES " \
                  "(%s, %s, %s, %s, %s, %s, %s, %s, %s)"
            cursor.execute(sql, ('Physical Spot Price Run - 10072',
                                 'Same as DSR_Red