No More Codes

# -*- coding: utf-8 -*-

"""

Created on Tue Mar 21 14:46:19 2017

@author: ghosty

package installation:

  pip install pymysql

"""

#!/usr/bin/python   

# 引入 MySQL 模組

import pymysql as mysql   

# 連接到 MySQL

db = mysql.connect(host="localhost", user="root", passwd="", db="finance")

cursor = db.cursor()

cursor.execute("SET NAMES 'UTF8'")

cursor.execute("SET CHARACTER_SET_RESULTS=UTF8")

TableName = "StockData"

strSQL = "CREATE TABLE IF NOT EXISTS `" \

        + TableName + "` (" \

        + "`Date` DATE NOT NULL ," \

        + "`StockID` DATE NOT NULL ," \

        + "`Open` FLOAT NOT NULL ,"\

        + "`High` FLOAT NOT NULL ,"\

        + "`Low`  FLOAT NOT NULL ,"\

        + "`Close` FLOAT NOT NULL ,"\

        + "`Volume` FLOAT NOT NULL,"\

        + "INDEX (Date, StockID) " \

        + ") ENGINE = MYISAM ;";

cursor.execute(strSQL)                     

db.close()