Python连接MySQL insert插入语句

import pymysql

conn = pymysql.Connect(host='127.0.0.1', port=3306,user='root',password='123456', db='study',
                       charset='utf8')

cursor = conn.cursor()

try:
    sql = 'insert into news (IID,url,title,author,content,`date`,`group`,`section`,CID,MID) values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)'
    values = (1234, 'url', 'title', 'author', 'content', None, 'd', 'fd', 12, 22)
    cursor.execute(sql, values)
    conn.commit()
except Exception as e:
    print('一场异常', e)
    conn.rollback()

sql语句和values分开通过格式符连接

`date`,`group`,`section`