程式小試身手

import pymysql

db = pymysql.connect("localhost","root","password","db_name" )

def openDataBase():
    cursor = db.cursor()
    cursor.execute("SELECT * FROM tabel_name Join tabel_name2 on tabel_name.id=tabel_name2.id and tabel_name2.category =''category_name")
 

def writeDB():
   cursor = db.cursor()
   cursor.execute ("""UPDATE tabel_name
   SET 1_rate=%s, 2_rate=%s WHERE id=%s
   """, ('1', '1','id'))
   
   db.commit()

db.close()