2023年8月3日发(作者：)

python数据库execute执⾏update_Python对Mysql的操作（新建更新删除）利⽤Python对mysql进⾏读写操作，创建数据库，插⼊数据，更新数据，删除数据等操作。连接数据库#!/usr/bin/python# -*- coding: UTF-8 -*-import MySQLdb# 打开数据库连接db = t("localhost", "testuser", "test123", "TESTDB", charset='utf8' )# 使⽤cursor()⽅法获取操作游标cursor = ()# 使⽤execute⽅法执⾏SQL语句e("SELECT VERSION()")# 使⽤ fetchone() ⽅法获取⼀条数据data = ne()print "Database version : %s " % data# 关闭数据库连接()创建数据库表#!/usr/bin/python# -*- coding: UTF-8 -*-import MySQLdb# 打开数据库连接db = t("localhost", "testuser", "test123", "TESTDB", charset='utf8' )# 使⽤cursor()⽅法获取操作游标cursor = ()# 如果数据表已经存在使⽤ execute() ⽅法删除表。e("DROP TABLE IF EXISTS EMPLOYEE")# 创建数据表SQL语句sql = """CREATE TABLE EMPLOYEE (FIRST_NAME CHAR(20) NOT NULL,LAST_NAME CHAR(20),AGE INT,SEX CHAR(1),INCOME FLOAT )"""e(sql)# 关闭数据库连接()数据库插⼊操作#!/usr/bin/python# -*- coding: UTF-8 -*-import MySQLdb# 打开数据库连接db = t("localhost", "testuser", "test123", "TESTDB", charset='utf8' )# 使⽤cursor()⽅法获取操作游标cursor = ()# SQL 插⼊语句sql = """INSERT INTO EMPLOYEE(FIRST_NAME,LAST_NAME, AGE, SEX, INCOME)VALUES ('Mac', 'Mohan', 20, 'M', 2000)"""try:# 执⾏sql语句e(sql)# 提交到数据库执⾏()except:# Rollback in case there is any ck()# 关闭数据库连接()数据库查询操作#!/usr/bin/python# -*- coding: UTF-8 -*-import MySQLdb# 打开数据库连接db = t("localhost", "testuser", "test123", "TESTDB", charset='utf8' )# 使⽤cursor()⽅法获取操作游标cursor = ()# SQL 查询语句sql = "SELECT * FROM EMPLOYEE WHERE INCOME > %s" % (1000)try:# 执⾏SQL语句e(sql)# 获取所有记录列表results = ll()for row in results:fname = row[0]lname = row[1]age = row[2]sex = row[3]income = row[4]# 打印结果print "fname=%s,lname=%s,age=%s,sex=%s,income=%s" % (fname, lname, age, sex, income )except:print "Error: unable to fecth data"# 关闭数据库连接()数据库更新操作#!/usr/bin/python# -*- coding: UTF-8 -*-import MySQLdb# 打开数据库连接db = t("localhost", "testuser", "test123", "TESTDB", charset='utf8' )# 使⽤cursor()⽅法获取操作游标cursor = ()# SQL 更新语句sql = "UPDATE EMPLOYEE SET AGE = AGE + 1 WHERE SEX = '%c'" % ('M')try:# 执⾏SQL语句e(sql)# 提交到数据库执⾏()except:# 发⽣错误时回滚ck()# 关闭数据库连接()删除操作#!/usr/bin/python# -*- coding: UTF-8 -*-import MySQLdb# 打开数据库连接db = t("localhost", "testuser", "test123", "TESTDB", charset='utf8' )# 使⽤cursor()⽅法获取操作游标cursor = ()# SQL 删除语句sql = "DELETE FROM EMPLOYEE WHERE AGE > %s" % (20)try:# 执⾏SQL语句e(sql)# 提交修改()except:# 发⽣错误时回滚ck()# 关闭连接()

2023年8月3日发(作者：)

python数据库execute执⾏update_Python对Mysql的操作（新建更新删除）利⽤Python对mysql进⾏读写操作，创建数据库，插⼊数据，更新数据，删除数据等操作。连接数据库#!/usr/bin/python# -*- coding: UTF-8 -*-import MySQLdb# 打开数据库连接db = t("localhost", "testuser", "test123", "TESTDB", charset='utf8' )# 使⽤cursor()⽅法获取操作游标cursor = ()# 使⽤execute⽅法执⾏SQL语句e("SELECT VERSION()")# 使⽤ fetchone() ⽅法获取⼀条数据data = ne()print "Database version : %s " % data# 关闭数据库连接()创建数据库表#!/usr/bin/python# -*- coding: UTF-8 -*-import MySQLdb# 打开数据库连接db = t("localhost", "testuser", "test123", "TESTDB", charset='utf8' )# 使⽤cursor()⽅法获取操作游标cursor = ()# 如果数据表已经存在使⽤ execute() ⽅法删除表。e("DROP TABLE IF EXISTS EMPLOYEE")# 创建数据表SQL语句sql = """CREATE TABLE EMPLOYEE (FIRST_NAME CHAR(20) NOT NULL,LAST_NAME CHAR(20),AGE INT,SEX CHAR(1),INCOME FLOAT )"""e(sql)# 关闭数据库连接()数据库插⼊操作#!/usr/bin/python# -*- coding: UTF-8 -*-import MySQLdb# 打开数据库连接db = t("localhost", "testuser", "test123", "TESTDB", charset='utf8' )# 使⽤cursor()⽅法获取操作游标cursor = ()# SQL 插⼊语句sql = """INSERT INTO EMPLOYEE(FIRST_NAME,LAST_NAME, AGE, SEX, INCOME)VALUES ('Mac', 'Mohan', 20, 'M', 2000)"""try:# 执⾏sql语句e(sql)# 提交到数据库执⾏()except:# Rollback in case there is any ck()# 关闭数据库连接()数据库查询操作#!/usr/bin/python# -*- coding: UTF-8 -*-import MySQLdb# 打开数据库连接db = t("localhost", "testuser", "test123", "TESTDB", charset='utf8' )# 使⽤cursor()⽅法获取操作游标cursor = ()# SQL 查询语句sql = "SELECT * FROM EMPLOYEE WHERE INCOME > %s" % (1000)try:# 执⾏SQL语句e(sql)# 获取所有记录列表results = ll()for row in results:fname = row[0]lname = row[1]age = row[2]sex = row[3]income = row[4]# 打印结果print "fname=%s,lname=%s,age=%s,sex=%s,income=%s" % (fname, lname, age, sex, income )except:print "Error: unable to fecth data"# 关闭数据库连接()数据库更新操作#!/usr/bin/python# -*- coding: UTF-8 -*-import MySQLdb# 打开数据库连接db = t("localhost", "testuser", "test123", "TESTDB", charset='utf8' )# 使⽤cursor()⽅法获取操作游标cursor = ()# SQL 更新语句sql = "UPDATE EMPLOYEE SET AGE = AGE + 1 WHERE SEX = '%c'" % ('M')try:# 执⾏SQL语句e(sql)# 提交到数据库执⾏()except:# 发⽣错误时回滚ck()# 关闭数据库连接()删除操作#!/usr/bin/python# -*- coding: UTF-8 -*-import MySQLdb# 打开数据库连接db = t("localhost", "testuser", "test123", "TESTDB", charset='utf8' )# 使⽤cursor()⽅法获取操作游标cursor = ()# SQL 删除语句sql = "DELETE FROM EMPLOYEE WHERE AGE > %s" % (20)try:# 执⾏SQL语句e(sql)# 提交修改()except:# 发⽣错误时回滚ck()# 关闭连接()