pymysql操作数据库

连接方法：

import pymysql

1、

def db_connect():
    return pymysql.connect('127.0.0.1', 'yang', '123456', 'dbtest', port=3306, charset='utf8')

db = db_connect()

2、

connection = pymysql.connect(
                             host='127.0.0.1',
                             port=3306,
                             user='root',
                             password='zhyea.com',
                             db='employees',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

3、

config = {
          'host':'127.0.0.1',
          'port':3306,
          'user':'root',
          'password':'zhyea.com',
          'db':'employees',
          'charset':'utf8mb4',
          'cursorclass':pymysql.cursors.DictCursor,
          }
 
# Connect to the database
connection = pymysql.connect(**config)