pymysql的使用

凉凉了，，，，

1 import pymysql
2 db = pymysql.connect(host = 'localhost',user = 'root',password ='123456',port =3306)
3 cursor = db.cursor()
4 cursor.execute('SELECT VERSION()')
5 data = cursor.fetchone()
6 print('D:',data)
7 cursor.execute("CREATE DATABASE spiders DEFAULT CHARACTER SET utf8")
8 db.close()

 

posted @ 2018-06-06 22:43  zzuli风尘  阅读(94)  评论(0)    收藏  举报