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()
原文地址:https://www.cnblogs.com/kangdong/p/9147830.html