import pymysql
db = pymysql.connect(
host=“127.0.0.1”,
user=‘root’,
password=‘11111111’,
database=“pymysql_test”,
port=3306
)
cursor = db.cursor()
cursor.execute(“select * from article”)
result = cursor.fetchone() # 提取第一条数据
print(result)
import pymysql
db = pymysql.connect(
host=“127.0.0.1”,
user=‘root’,
password=‘11111111’,
database=“pymysql_test”,
port=3306
)
cursor = db.cursor()
cursor.execute(“select * from article”)
result = cursor.fetchone() # 提取第一条数据
print(result)