数据存储

存入数据库mysql

import pymysql

con=pymysql.connect(host='localhost',port=3306,user='root',passwd='123456',db='test',charset='utf8',connect_timeout=1000)

con=pymysql.connect('localhost','root','123456','test')

可视化工具：navicat

游标：
cursor=con.cursor()

sql='create table if not exists class (id int(10) primary key auto_increment, name varchar(20) not null, text varchar(20)not null )'

cursor.execute(sql)

cursor.execute('show tables')

sql='insert into class(name,text) values(%s,%s)'

cursor.execute(sql,(title,target))

con.commit()

data=cursor.execute('select * from class')

data=cursor.fetchmany()

con.close()