首先给出我的实例:
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