import pymysql
db = pymysql.connect(
host=“127.0.0.1”,
user=‘root’,
password=‘11111111’,
database=“pymysql_test”,
port=3306
)
cursor = db.cursor()
sql = “select id,title from article where id>3”
cursor.execute(sql)
result = cursor.fetchone()
result = cursor.fetchall()
result = cursor.fetchmany(6)
print(result)