国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 數據庫 > MySQL > 正文

Python MySQL進行數據庫表變更和查詢

2024-07-24 13:13:14
字體:
來源:轉載
供稿:網友

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.commit()   except:     db.rollback()  def do_query(cursor,db):   sql = "SELECT * FROM EMPLOYEE /      WHERE INCOME > '%d'" % (1000)   try:     # Execute the SQL command     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]       income = row[4]       # Now print fetched result       print "fname=%s,lname=%s,age=%d,sex=%s,income=%d" % /           (fname, lname, age, sex, income )   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.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() 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()  

之后可以在此基礎上根據需要進行封裝。

感謝閱讀,希望能幫助到大家,謝謝大家對本站的支持!


注:相關教程知識閱讀請移步到MYSQL教程頻道。
發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 水城县| 汤原县| 宣城市| 济宁市| 宜春市| 茶陵县| 长丰县| 新龙县| 吕梁市| 始兴县| 留坝县| 泗水县| 长海县| 横峰县| 上杭县| 沈丘县| 南投市| 历史| 台北县| 永善县| 诸城市| 保山市| 建德市| 乌鲁木齐县| 鸡东县| 万源市| 四子王旗| 北海市| 太白县| 精河县| 海城市| 渭源县| 吉安县| 闽清县| 侯马市| 天峨县| 蓬安县| 阳曲县| 蒙城县| 九龙县| 星座|