python连接数据库

打开数据库

数据准备

create database class;
use class;
create table student(id int(4),name varchar(11));
insert into student value(1,'aaa');
insert into student value(2,'aafa');

基础代码的实现

# 导入mysql的包
import pymysql

# 创建连接对象
conn = pymysql.connect(host="localhost"</