python30 python操作mysql

# python 操作数据库
# /usr/sbin/py/python
# -*-coding:utf8-*-
import sys
import pymysql  # 外部包 pychar控制台 执行 pip install pymysql 即可

conn = pymysql.connect(host="localhost", port=3306, user="root", passwd="admin123", db="mymember")

cursor = conn.cursor()

# sqlCreatePerson = "create table myPerson(id int,name varchar(20),age int)"
# cursor.execute(sqlCreatePerson)
# sqlInserPerson ="insert into myperson values (1,'jake',10),(2,'tom',12)"
# cursor.execute(sqlInserPerson)
sqlQueryPerson = "select * from myperson"
resultCount = cursor.execute(sqlQueryPerson)

print(resultCount)
print(cursor.fetchall())  # 全部取出
print(cursor.fetchmany(2))  # 之前已经全部取出了，游标再往下走就没数据了
cursor.scroll(-1, mode="relative")  # 相对当前位置移动 (-1 表示向上，+1 表示向上)
print(cursor.fetchall())
cursor.scroll(0, mode="absolute")  # 游标的绝对位置从0开始
print(cursor.fetchall())
conn.commit()
cursor.close()
conn.close()

-----------------------

事物

# python db 事物
# /usr/sbin/py/python
# -*-coding:utf8-*-

import pymysql

conn = pymysql.connect(host="localhost", port=3306, user="root", passwd="admin123", db="mymember")

cursor = conn.cursor()
try:
    sqlInsert = ("insert into myperson values (3,'jake',10)")
    cursor.execute(sqlInsert)
    conn.commit()
except Exception as ex:
    conn.rollback()

cursor.close()
conn.close()