獲取查詢數(shù)據(jù)

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()

插入數(shù)據(jù)

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數(shù)據(jù)類型

關(guān)于默認(rèn)獲取的數(shù)據(jù)是元祖類型，如果想要或者字典類型的數(shù)據(jù)，即：

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()