Python MySQL进行数据库表变更和查询
网络编程 2021-07-05 14:36www.168986.cn编程入门
这篇文章主要介绍了Python MySQL进行数据库表变更和查询的相关资料,需要的朋友可以参考下
Python连接MySQL,进行数据库表变更和查询:
python mysql insert delete query:
#!/usr/bin/python import MySQLdb def doInsert(cursor,db): #insert # Prepare SQL query to INSERT a record into the database. sql = "UPDATE EMPLOYEE SET AGE = AGE+1 WHERE SEX = '%c'" %('M') try: cursor.execute(sql) db.mit() except: db.rollback() def do_query(cursor,db): sql = "SELECT * FROM EMPLOYEE \ WHERE INCOME > '%d'" % (1000) try: # Execute the SQL mand cursor.execute(sql) # Fetch all the rows in a list of lists. results = cursor.fetchall() print 'resuts',cursor.rowcount for row in results: fname = row[0] lname = row[1] age = row[2] sex = row[3] ine = row[4] # Now print fetched result print "fname=%s,lname=%s,age=%d,sex=%s,ine=%d" % \ (fname, lname, age, sex, ine ) except: print "Error: unable to fecth data" def do_delete(cursor,db): sql = 'DELETE FROM EMPLOYEE WHERE AGE > {}'.format(20) try: cursor.execute(sql) db.mit() except: db.rollback() def do_insert(cursor,db,firstname,lastname,age,sex,ine): sql = "INSERT INTO EMPLOYEE(FIRST_NAME, \ LAST_NAME, AGE, SEX, INCOME) \ VALUES ('%s', '%s', '%d', '%c', '%d' )" % \ (firstname,lastname,age,sex,ine) try: cursor.execute(sql) db.mit() except: db.rollback() # Open database connection # change this to your mysql aount #connect(server,username,password,db_name) db = MySQLdb.connect("localhost","root","root","pydb" ) # prepare a cursor object using cursor() method cursor = 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 server db.close()
之后可以在此基础上根据需要进行封装。
感谢阅读,希望能帮助到大家,谢谢大家对本站的支持!
编程语言
- 机械手焊接机器人编程 机械手焊接设备编程
- vb数据库编程实例,vb做数据库
- tiobe世界编程语言排行榜,全球编程语言排行
- 成都java编程培训 成都it编程培训中心
- 编程基础培训,编程基础知识培训
- flash游戏编程基础教程,flash游戏开发教程
- 不会英语能学编程吗 不会英语可以学程序员吗
- 爱心代码编程C语言 爱心代码编程c语言公式
- c语言编程学习入门 c语言编程快速入门
- 西门子plc编程培训 西门子plc编程培训班
- 哪里可以学编程 台州哪里可以学编程
- 少儿编程哪个好 少儿编程哪个品牌好
- 编程是什么意思,图形编程是什么意思
- c语言编程软件下载,c语言编程软件在哪下载
- java编程软件下载,java编程下载手机版
- ug编程培训学校,ug编程培训教程