python：将表格中的内容导入mysql并实现数据库的更新

import pandas as pd
import pymysql
import csv
from collections import namedtuple
import pymysql
import re


#判断表是否在库中
def table_exists(con, table_name):
    sql = "show tables;"
    con.execute(sql)
    tables = [con.fetchall()]
    print(tables)
    table_list = re.findall('(\'.*?\')', str(tables))
    table_list = [re.sub("'", '', each) for each in table_list]
    if table_name in table_list:
        # 存在返回1
        return 1
    else:
        # 不存在返回0
        return 0


#创建数据库
def create_database(database_name,table_name):
    db = pymysql.connect(host="127.0.0.1", port=3306, user="root", password="anywhere",
                           database="qt_students_try", charset="utf8")
    cur = db.cursor()
    sql = 'create database if not exists {}'.format(database_name)
    cur.execute(sql)
    cur.execute("use {}".format(database_name))
    if (table_exists(cur, table_name) == 1):
        pass
    else:
        sql = 'create table {}(' \
              'id int(255) primary key not null auto_increment,' \
              'name varchar(255),gender varchar(255))'.format(table_name)
              #'name varchar(255))'.format(table_name)
        cur.execute(sql)
        db.commit()
    db.close()

def get_data(file_name):
    with open(file_name) as f:
        f_csv = csv.reader(f)
        headings = next(f_csv)
        Row = namedtuple('Row', headings)
        for r in f_csv:
            yield Row(*r)

def execute_sql(conn, sql):
    with conn.cursor() as cur:
        cur.execute(sql)

        print('执行成功')


def main():
    conn = pymysql.connect(host="127.0.0.1", port=3306, user="root", password="anywhere",
                                   database="qt_students_try", charset="utf8")
    # 将CSV文件中的数据插入MySQL数据表中
    SQL_FORMAT = """insert into student_info values('{0}', '{1}', '{2}')"""
    conn.autocommit(1)
    print(1)
    # for t in get_data('./data/student.csv'):
    for t in get_data('./info.csv'):
        print(12)
        print(t.id, t.name, t.gender)
        sql = SQL_FORMAT.format(t.id, t.name, t.gender)
        print(sql)
        execute_sql(conn, sql)
    conn.commit()  # 提交到数据库
    conn.close()  # 关闭数据库服务


if __name__ == '__main__':
    database_name = 'qt_students_try'
    table_name = 'student_info'
    create_database(database_name,table_name)
    main()

更新数据库中的数据（在上述def main（）中的‘conn.commit()  # 提交到数据库’之前添加下述代码）

    SQL_FORMAT = """insert into student_info values('{0}', '{1}')"""
    id1=11
    pass1='Q'
    sql = "UPDATE student_info SET password= '%s' WHERE id = %d" % (pass1,id1)
    execute_sql(conn, sql)