python中的mysql

import pymysql
conobj=pymysql.connect('localhost','root','1234','test',charset='utf8')
curobj=conobj.cursor()

#执行
curobj.execute('select version()')
res=curobj.fetchone()
print(res)
curobj.execute('drop table if exists books')
sql ="""
CREATE TABLE BOOKS(
  id int(8) NOT NULL AUTO_INCREMENT,
  NAME VARCHAR(50) NOT NULL,
  CATEGORY varchar(50),
  PRIMARY KEY(id)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=UTF8;
"""
curobj.execute(sql)

#关闭连接
curobj.close()
conobj.close()

插入

data1=[('a','b','c'),
	   ('e','s','f'),
	   ('r','g','v')]
sql="insert into books (name,category,prince) values(%s,%s,%s)"
curobj.executemany(sql,data1)

#回滚
try:
    ##
    ##
    ##
except:
    conobj.rollback()#失败回滚