python3操作mysql数据库增删改查

来源：互联网发布：文档软件下载编辑：程序博客网时间：2024/05/20 05:57

python3.x 使用pymysql操作mysql，python2.x使用mysqldb操作mysql

#!/usr/bin/python3import pymysqlimport typesdb=pymysql.connect("localhost","root","123456","python");cursor=db.cursor()#创建user表cursor.execute("drop table if exists user")sql="""CREATE TABLE IF NOT EXISTS `user` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `name` varchar(255) NOT NULL,  `age` int(11) NOT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0"""cursor.execute(sql)#user插入数据sql="""INSERT INTO `user` (`name`, `age`) VALUES('test1', 1),('test2', 2),('test3', 3),('test4', 4),('test5', 5),('test6', 6);"""try:   # 执行sql语句   cursor.execute(sql)   # 提交到数据库执行   db.commit()except:   # 如果发生错误则回滚   db.rollback()      #更新id=1sql="update user set age=100 where id='%s'" % (id)try:cursor.execute(sql)db.commit()except:db.rollback()#删除id=2sql="delete from user where id='%s'" % (id)try:cursor.execute(sql)db.commit()except:db.rollback()#查询cursor.execute("select * from user")results=cursor.fetchall()for row in results:name=row[0]age=row[1]#print(type(row[1])) #打印变量类型 <class 'str'>print ("name=%s,age=%s" % \             (age, name))

执行结果

[root@mail pythonCode]# python3 test.pyname=test1,age=1name=test3,age=3name=test4,age=4name=test5,age=5name=test6,age=6

0 0