MySQL Connector/Python 和 pyodbc

pyodbc：

import pyodbc

conn_mysql = pyodbc.connect('DRIVER={MySQL ODBC 8.0 Unicode Driver};SERVER=' + server_mysql + ';DATABASE='+database_mysql + ';UID='+user_mysql + ';PWD=' + password_mysql)
cursor_mysql = conn_mysql.cursor()

update_cmd_mysql = ("UPDATE yshi2.IDEAS_2016 "
                    "SET Tool_Chain = ?, Rec_ID=?, BHA_ID=?, Rock_Hardness=?, Mud_Weight_ppg=?, Mud_Type=? "
                          "WHERE `Track num`=? AND `Case Index`=? AND `ObjectiveCategory`=? AND `WhichProgram`=?") #Parameters的由?标记

update_values = get_values()
cursor_mysql.execute(update_cmd_mysql, update_values)
conn_mysql.commit()
cursor_mysql.close()
conn_mysql.close()

 

MySQL Connector/Python：　　

from mysql.connector import errorcode

try:
    cnx = mysql.connector.connect(user=user_mysql, password=password_mysql,
                                host=server_mysql,
                                database=database_mysql)
    cursor = cnx.cursor()

    for i in range(2):
        update_values = get_values()
        cursor.execute(update_cmd_mysql, update_values) #parameter由%s标注

except mysql.connector.Error as err:
  if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
    print("Something is wrong with your user name or password")
  elif err.errno == errorcode.ER_BAD_DB_ERROR:
    print("Database does not exist")
  else:
    print(err)
else:
    cnx.commit()
    cnx.close()