pymysql 插入数据

插入数据

import pymysql
db = pymysql.connect('localhost', 'root', '123456', 'heimdall')
cursor = db.cursor()

sql = "INSERT INTO employee(id, name, sex)VALUSE(1, 'rose', '男')"

• 如果插入失败就回滚，就如海姆达尔可以通过拔出剑来终止连接
  try: corsor.execute(sql) db.commit() except: db.rollback()

db.close()