安裝

官網(wǎng)下載windows的install文件安裝

使用
mysql測(cè)試

# coding=utf-8
import mysql.connector
# 注意把password設(shè)為你的root口令:
conn = mysql.connector.connect(user='root', password='root', database='test')
cursor = conn.cursor()
# 創(chuàng)建user表:
cursor.execute('create table user (id varchar(20) primary key, name varchar(20))')
# 插入一行記錄，注意MySQL的占位符是%s:
cursor.execute('insert into user (id, name) values (%s, %s)', ['1', 'Michael'])
# 提交事務(wù):
conn.commit()
cursor.close()
# 運(yùn)行查詢:
cursor = conn.cursor()
cursor.execute('select * from user where id = %s', ['1'])
values = cursor.fetchall()
# 關(guān)閉Cursor和Connection:
cursor.close()
conn.close()

錯(cuò)誤出現(xiàn)

Paste_Image.png

經(jīng)查詢是沒(méi)有安裝mysql包

原來(lái)已經(jīng)不用mysqldb了
下載安裝mysql包

python -m pip install PyMySQL

Paste_Image.png

安裝

easy_install.exe pymysql3

Paste_Image.png

最終版本

    # coding=utf-8
    import pymysql
    conn = pymysql.connect(user='root', passwd='root',host='localhost', db='test')
    # conn = pymysql.connector.connect(user='root', password='root', database='test')
    cursor = conn.cursor()
    # 創(chuàng)建user表:
    cursor.execute('create table user (id varchar(20) primary key, name varchar(20))')
    # 插入一行記錄，注意MySQL的占位符是%s
    cursor.execute('insert into user (id, name) values (%s, %s)', ['1', 'Michael'])
    
    # 提交事務(wù):
    conn.commit()
    cursor.close()
    # 運(yùn)行查詢:
    cursor = conn.cursor()
    cursor.execute('select * from user where id = %s', ['1'])
    values = cursor.fetchall()
    # 關(guān)閉Cursor和Connection:
    cursor.close()
    conn.close()

執(zhí)行

Paste_Image.png

并沒(méi)有什么效果
看下數(shù)據(jù)庫(kù)

Paste_Image.png

Paste_Image.png