这里提前创建好数据库 并加入一些测试数据
create database pythondb;
user pythondb;
create table python_user(
userid varchar(50) primary key not null,
username varchar(50) not null
);
insert into python_user values('123456','张三');
insert into python_user values('654321','李四');
执行上面sql代码之后数据库表内测试数据如下:
具体Python代码链接数据库代码如下:
import pymysql
try:
connection = pymysql.connect(host='localhost', user='root', password='123456', db='pythondb', charset='utf8')
print(connection)
cursor = connection.cursor()
sql = 'select * from python_user'
cursor.execute(sql)
data = cursor.fetchall()
print(data)
for user in data:
print('姓名:', user[1], '学号:', user[0])
except Exception as e:
print(e)