安裝PyMySQL
pip3 install PyMySQL
···
其他方式
git clone https://github.com/PyMySQL/PyMySQL
cd PyMySQL/
python setup.py install
鏈接數(shù)據(jù)庫(kù)
import pymysql
db = pymysql.connect("localhost","用戶(hù)名","密碼","數(shù)據(jù)庫(kù)名稱(chēng)")
//創(chuàng)建一個(gè)游標(biāo)對(duì)象
cursor = db.cursor()
//執(zhí)行execute()方法執(zhí)行sql語(yǔ)句
//關(guān)閉
db.close()
創(chuàng)建數(shù)據(jù)庫(kù)表
cursor = db.cursor()
cursor.execute("DROP TABLE STUDENT")
sql = """
CREATE TABLE student (
id int not null auto_increment primary key,
name varchar(20) not null,
school varchar(20)
)
"""
cursor.execute(sql)
db.commit()
db.close()
新增與查詢(xún)
#新增
sql = """
INSERT INTO student(name,school) value("xiao","火影")
"""
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
print("提交異常")
#查詢(xún)
sql = "SELECT * FROM student"
try:
cursor.execute(sql)
result = cursor.fetchall()
for r in result:
print(r)
except:
print("Error !")
