XcXaz7q6

1<` db = MySQLdb.connect("127.0.0.1", "root", "1234")
2                cursor = db.cursor()
3                try:
4                    cursor.execute('create database nasa')
5                except:
6                    None
7                cursor.execute('use nasa')
8
9                cursor.execute(
10                    "CREATE TABLE IF NOT EXISTS temperatureTable(date VARCHAR(30) NOT NULL, time VARCHAR(30) NOT NULL, longitude VARCHAR(30) NOT NULL, latitude VARCHAR(30) NOT NULL, temperature VARCHAR(30) NOT NULL, PRIMARY KEY (date, longitude, latitude))")
11                lineToBeStored = 0
12                for lat in numpy.nditer(latitude):
13                    for lon in numpy.nditer(longitude):
14                        cursor.execute(
15                            "INSERT INTO temperatureTable VALUES('%s', '%s', '%s', '%s', '%s')" % (
16                                today, dateTime, lat, lon, temperatureData[lineToBeStored]))`>