Python 连接 Mysql

连接Mysql数据库

execute来执行sql语句

    conn = pymysql.connect(host='localhost',user='root',password='******',database='test')
    print("连接")
    corsor = conn.cursor()
    corsor.execute('DROP TABLE IF EXISTS Student')
    sqlQuery = "CREATE TABLE Student(Name CHAR(20) NOT NULL ,MARJOR CHAR(20) NOT NULL ,NUM CHAR(15) NOT NULL)"
    corsor.execute(sqlQuery)

插入数据

在最后必须使用commit函数来记录数据库的变化

    conn = pymysql.connect(host='localhost',user='root',password='qq123123',database='test')
    print("连接")
    corsor = conn.cursor()
    sqlQuery = " INSERT INTO Student(Name,MARJOR,NUM) VALUE (%s,%s,%s)"
    value = ('zlf','物联网','542007130326')
    corsor.execute(sqlQuery,value)
    conn.commit()

展示数据

fetchall匹配所有的数据

    conn = pymysql.connect(host='localhost',user='root',password='qq123123',database='test')
    print("连接")
    corsor = conn.cursor()
    sqlQuery = "SELECT * FROM Student"
    corsor.execute(sqlQuery)
    result = corsor.fetchall()
    print('result:',result)
    conn.close()