安裝
官網(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)
經(jīng)查詢是沒(méi)有安裝mysql包
原來(lái)已經(jīng)不用mysqldb了
下載安裝mysql包
python -m pip install PyMySQL
安裝
easy_install.exe pymysql3
最終版本
# 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í)行
并沒(méi)有什么效果
看下數(shù)據(jù)庫(kù)
