python处理mysql的的方案汇总

connect：

import mysql.connector
from mysql.connector import errorcode

try:
 cnx = mysql.connector.connect(user='scott', password='tiger',
                                 host='127.0.0.1',
                                 database='employees')
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.close()
create table

import mysql.connector
from mysql.connector import errorcode

cnx = mysql.connector.connect(user='scott')
cursor = cnx.cursor()

try:
 cursor.execute( "CREATE DATABASE {} DEFAULT CHARACTER SET 'utf8'".format(DB_NAME))
except mysql.connector.Error as err:
 print("Failed creating database: {}".format(err))
 exit(1)
query

import mysql.connector
conn = mysql.connector.connect(host=’127.0.0.1’, user='root', password='root', database='athena')
cursor = conn.cursor(dictionary=True)
try:
 cursor.execute(sql)
 rows = cursor.fetchall()
finally:
 conn.close()