仓库源文，站点原文

{% code %} import pymysql

连接方法

conn = pymysql.connect( host='0.0.0.0', port=3306, user='root', passwd='123456', db='test')

创建当前游标

cursor = conn.cursor()

effect_row 为结果行数

effect_row = cursor.execute("select * from student")

建立需要插入的数据

data = [ ('MM',33), ('BearBear',4), ('q',10) ]

执行插入多条语句

cursor.executemany('insert into student(name,age) values(%s,%s)',data)

执行插入单条带变量的语句

data = cursor.execute("insert into user(username,age,department) values('{0}','{1}','{2}')".format(username,age,department))

提交语句

conn.commit()

执行更新语句

cursor.execute('update student set name="q" where id = 1')

conn.commit()

执行删除语句

cursor.execute('delete from student where name = "q"')

conn.commit()

cursor.close()

conn.close() {% endcode %}