原文地址:https://www.cnblogs.com/anpengapple/p/7127580.html
https://www.cnblogs.com/chenjingyi/p/5740415.html
连接数据库:
conn = pymysql.connect(host=host, user=user, passwd=password, db=db)
创建游标:
cur = conn.cursor()
执行SQL:
cur.execute(“INSERT INTO table VALUE something”)
cur.execute(“SELECT * FROM table”)
获取数据:
data = cur.fetchone()
data = cur.fetchmany()
data = cur.fetchall()
data是个生成器
关闭游标:
cur.close()
如果SQL是insert之类的DML语句,要记得commit:
conn.commit()
关闭数据库连接
conn.close()