anconda 调用时数据库代码

经过半天的研究，终于搞懂了anconda 调用mysql的用法。接下来继续学爬虫。
在这里插入代码片
"
Spyder Editor

import pymysql;
import numpy as np;

db=pymysql.connect(host=‘localhost’,user=‘root’,password=‘mysql’,port=3306)
cursor=db.cursor();
cursor.execute(‘SELECT VERSION()’);
data=cursor.fetchone();
print (‘Database version:’,data)
cursor.execute(“create database spider default character set utf8”)
cursor.execute(‘use spider’)
sql=‘create table if not exists student(id varchar(25) ,name varchar(25) ,age int(4) )’
cursor.execute(sql)
cursor.execute(‘desc student’)

sql=“INSERT INTO student VALUES(‘20’,‘那’,11)”
cursor.execute(sql)
db.commit()
sql=“INSERT INTO student VALUES(‘21’,‘在’,31)”
cursor.execute(sql)
db.commit()

cursor.execute(“select * from student”)
data1=cursor.fetchall()
print(‘data:’,data1)
db.close()

今天的代码学习就到这了。