python插入一条sql数据示例

import os, sys 
import MySQLdb

try: 
    conn = MySQLdb.connect(host='localhost', user='root', passwd='', db='') 
except MySQLdb.Error as e: 
    print(e)

cursor = conn.cursor() 
sql = "INSERT INTO test (mobile) VALUES (%s)" 
values = [('17701234567',)]
try: 
    cursor.executemany(sql, values) 
    conn.commit() 
except MySQLdb.Error as e:
    print(e) 
    conn.rollback() 
    sys.exit()

cursor.close() 
conn.close()