db

import MySQLdb


def creatTB(cursor):
    sql = "CREATE TABLE student_info(ID int, "\
          "name varchar(255)," \
          "sex varchar(12)," \
          "subject_1 varchar(255)," \
          "techang varchar(255))"
    cursor.execute(sql)
    print("create table success")

def insert(db,cursor):
    sql = "insert into student_info(ID,name,sex,subject_1,techang) values (%s,%s,%s,%s,%s)"
    var = ("1", "roy", "boy", "12", "English", "read")
    cursor.execute(sql, var)
    db.commit()
    print("successfully insert data")

def select(cursor, key, value):
    sql = "select * from student_info where " + key + "=" + value
    cursor.execute(sql)

if __name__ == '__main__':
    db = MySQLdb.connect(host='localhost',  # 本地数据库
                         user='root',  # 用户名
                         passwd='XXXXX',  # 数据库密码
                         db='test',  # 数据库名
                         charset='utf8')
    cursor = db.cursor()
    creatTB(cursor)
    insert(db, cursor)
    db.close()