pymysql创建数据库

cursor里的execute方法是可以执行所有mysql语句，如：

In [79]: conn = pymysql.connect(host="127.0.0.1",user='root',password='root')
In [80]: cursor = conn.cursor()
In [81]: cursor.execute("create database if not exists datastats")
Out[81]: 1

In [82]: cursor.execute('show databases')
Out[82]: 17

In [83]: cursor.fetchall()
Out[83]:
(('information_schema',),
...
In [94]: cursor.execute('use datastats')
Out[94]: 0