python操作数据库

获取查询数据

import pymysql


conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', db='studydb')
cursor = conn.cursor()
cursor.execute('select * from student WHERE stu_id>%s and name=%s', (3, 'alex'))

row_1 = cursor.fetchone()
row_3 = cursor.fetchmany(3)
row_a = cursor.fetchall()
print(row_1, row_3, row_a)

conn.commit()
cursor.close()
conn.close()

插入数据

import pymysql

conn = pymysql.connect(host='127.0.0.1', port=3306, user='root',passwd='', db='studydb')
cursor = conn.cursor()
cursor.executemany('insert into student(name,age,register_date)VALUES (%s,%s,%s)',
                   [('eric', 20, '2016-5-24'), ('eric', 20, '2016-5-24')])


conn.commit()
cursor.close()
conn.close()

fetch数据类型

关于默认获取的数据是元祖类型，如果想要或者字典类型的数据，即：

import pymysql


conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', db='studydb')
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
cursor.execute('select * from student WHERE stu_id>%s', (3,))

row = cursor.fetchall()
print(row)

conn.commit()
cursor.close()
conn.close()