So im trying to insert values into a MYSQL database table but the following error keeps on popping up.
would really appreciate some help.

This is my code which i wrote to input a value from a file and store it in a database table.

```
import mysql.connector
import pickle
try:
    connection = mysql.connector.connect(host='localhost',
                                         database='PETROL',
                                         user='Sarthak',
                                         password='q1w2e3r4t5')
    cursor = connection.cursor ( )
    print(connection)
    fp1 = open ("D:/Python/petrol/pdate/pdate.txt" , "rb+")
    while True :
        try :
            pdate = pickle.load (fp1)
            cursor.execute("DROP TABLE IF EXISTS DATES")
            cursor.execute("CREATE TABLE DATES (ID INT AUTO_INCREMENT PRIMARY KEY,Date DATE)")
            cursor.execute ("INSERT INTO DATES(Date) VALUES(pdate)")
            cursor.execute("SHOW TABLES")
            cursor.commit()
        except EOFError :
            fp6.close ()
except mysql.connector.Error as error:
    print("Failed to create table in MySQL: {}".format(error))
    cursor.close()
    connection.close()

```

The following error keeps on popping up -:

```
Failed to create table in MySQL: 1054 (42S22): Unknown column 'pdate' in 'field list'

```

I am not able to encounter what problem is caused by the insert statement which i wrote.