import numpy as np
import pymysql
conn = pymysql.connect(
    host = "localhost",
    user = "root",
    password = "Meiguo2017!",
    database = "HOUSEPRICE")

cursor = conn.cursor()
with open('~/desktop/Research/House_price/Zillow/06/ZAmt\SaleData.txt') as f:
    f.readline()
    print(f)
f.close()


sql = """
    SHOW TABLES;
"""
cursor.execute(sql)

#if conn:
    #print("data base has already connected")

conn.close()