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()
今天的代码学习就到这了。
