python连接mysql

---

1. 安装PyMySQL

$ pip install pymysql

github地址

2. select操作

import pymysql

connection = pymysql.connect(
    host="localhost",
    port = 3306,
    user = "root",
    password = "root",
    db = "test",
    charset = "utf8"
)

cur = connection.cursor()
cur.execute("select * from test")
# row = cur.fetchone()
# print (row)
res = cur.fetchall()
for row in res:
    print (row)
connection.close()

val = input("press any key to exit ...")

3. insert操作

with connection.cursor() as cur:
    sql = "insert into test(id, name, age, description) values(11,'tony',%s,%s)"
    cur.execute(sql, (30, "this is description to tony ..."))
# connection is not autocommit by default.
# So you must commit to save your changes.
connection.commit()

4. 错误处理

# open the connection
# connection = pymysql.connect()
try:
    # with connection.cursor() as cursor:
    # do something with cursor
finally:
    # close the conection

赏

×

纯属好玩

扫码打赏，你说多少就多少

打开支付宝扫一扫，即可进行扫码打赏哦