校企合作网站建设,长宁微信手机网站制作,南宁网站优化排名推广,中建西部建设北方有限公司网站这篇文章主要介绍了Python MySQL进行数据库表变更和查询的相关资料,需要的朋友可以参考下Python连接MySQL#xff0c;进行数据库表变更和查询#xff1a;python mysql insert delete query#xff1a;#!/usr/bin/pythonimport MySQLdbdef doInsert(cursor,db):#insert# Prep…这篇文章主要介绍了Python MySQL进行数据库表变更和查询的相关资料,需要的朋友可以参考下Python连接MySQL进行数据库表变更和查询python mysql insert delete query#!/usr/bin/pythonimport MySQLdbdef doInsert(cursor,db):#insert# Prepare SQL query to INSERT a record into the database.sql UPDATE EMPLOYEE SET AGE AGE1 WHERE SEX %c %(M)try:cursor.execute(sql)db.commit()except:db.rollback()def do_query(cursor,db):sql SELECT * FROM EMPLOYEE \WHERE INCOME %d % (1000)try:# Execute the SQL commandcursor.execute(sql)# Fetch all the rows in a list of lists.results cursor.fetchall()print resuts,cursor.rowcountfor row in results:fname row[0]lname row[1]age row[2]sex row[3]income row[4]# Now print fetched resultprint fname%s,lname%s,age%d,sex%s,income%d % \(fname, lname, age, sex, income )except:print Error: unable to fecth datadef do_delete(cursor,db):sql DELETE FROM EMPLOYEE WHERE AGE {}.format(20)try:cursor.execute(sql)db.commit()except:db.rollback()def do_insert(cursor,db,firstname,lastname,age,sex,income):sql INSERT INTO EMPLOYEE(FIRST_NAME, \LAST_NAME, AGE, SEX, INCOME) \VALUES (%s, %s, %d, %c, %d ) % \(firstname,lastname,age,sex,income)try:cursor.execute(sql)db.commit()except:db.rollback()# Open database connection# change this to your mysql account#connect(server,username,password,db_name)db MySQLdb.connect(localhost,root,root,pydb )# prepare a cursor object using cursor() methodcursor db.cursor()do_query(cursor,db)doInsert(cursor,db)do_query(cursor,db)do_delete(cursor,db)do_query(cursor,db)do_insert(cursor,db,hunter,xue,22,M,2000)do_insert(cursor,db,mary,yang,22,f,5555)do_insert(cursor,db,zhang,xue,32,M,5000)do_insert(cursor,db,hunter,xue,22,M,333)do_query(cursor,db)# disconnect from serverdb.close()之后可以在此基础上根据需要进行封装。
