1.定义连接
import pymysql
dp = pymysql.connect(host='localhost',
user='root',
password='root',
database='new_schema') #打开数据库链接
2使用cursor创建一个游标对象
cursor = dp.cursor() #使用cursor创建一个游标对象
3.写出sql语句
sqlQuery = "select * from new_table"
4.执行sql语句
try:
cursor.execute(sqlQuery)
results = cursor.fetchall()
for row in results:
ID = row[0]
NAME = row[1]
print('ID:%s,姓名:%s'%(ID,NAME))
except pymysql.Error as e:
print("失败")
5.关闭数据库
dp.close()