python创建数据库

# -*- coding: utf-8 -*-
"""
Created on Fri Oct 27 09:39:25 2017
批量创建数据库
@author: Administrator
"""


import MySQLdb


conn= MySQLdb.connect(host='localhost', port=3306,user='root', passwd='5623', db='tsdb')
cur = conn.cursor()


# 创建数据表SQL语句   table名不能纯数字???否则报错1064
sql = """create table A000001(date datetime, 
         open FLOAT,
         high  FLOAT,  
         close FLOAT,
         low FLOAT,
         volume FLOAT,
         price_change FLOAT,
         p_change FLOAT,
         ma5 FLOAT,
         ma10 FLOAT,
         ma20 FLOAT,
         v_ma5 FLOAT,
         v_ma10 FLOAT,
         v_ma20 FLOAT,
         turnover FLOAT)"""  
try:    
    cur.execute(sql)
except Exception as e:
    print "错误是%s"%e
    
conn.commit()  
cur.close()  
conn.close()