Creating table - Python (pymsql) I created a table called "bike" with the columns: "Borough", "Date", "Latitude", "Longitude", "Area" and "Investigation". To set up the data type for each column, I had a look online and found out which data type would best suit my purposes. Ended up finding about DECIMAL and the meaning of the values inside brac…

Creating table - Python (pymsql)

import pymysql, sys

try:
    conn = pymysql.connect(host='localhost', 
                           port=3306, 
                           user='co302mc', 
                           passwd='mafol597', 
                           db='co302mc_bike_theft')
    cur = conn.cursor()
    cur.execute("CREATE TABLE bike (Id INT PRIMARY KEY AUTO_INCREMENT, Borough VARCHAR(20), Date DATE, Latitude DECIMAL(10, 8) NOT NULL, Longitude DECIMAL(10, 8) NOT NULL, Area VARCHAR(100), Investigaton VARCHAR(100))")
    data = cur.fetchall()
    print data

except Exception as e:
    print "couldn't connect to database",e
    sys.exit()