Python中mysql插入数据

import pandas as pd
import pymysql as ps

# state_dt='20190725'
# stock_code='601330'
# open='12.19'
# close='12.15'
# high='12.25'
# low='12.00'
# vol='136961.64'
# amount='165811.515'
# pre_close='12.24'
# amt_change='-0.09'
# pct_change='-0.7353'

conn=ps.connect(host='localhost',port=3306,user='root',password='root@123',db='stock',charset='utf8')
cursor = conn.cursor()

sql = "INSERT INTO stock_new(state_dt,stock_code,open,close,high,low,vol,amount,pre_close,amt_change,pct_change) values(20190725,601330,12.19,12.15,12.25,12.00,136961.64,165811.515,12.24,-0.09,-0.7353)" 

#sql="insert into stock_new(state_dt,stock_code,open,close,high,low,vol,amount,pre_close,amt_change,pct_change) 
 #    values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)"
try:
    #cursor.execute(sql,(state_dt,stock_code,open,close,high,low,vol,amount,pre_close,amt_change,pct_change))
    cursor.execute(sql)
    conn.commit()
except:
    conn.rollback()
    
    conn.close()