How do I insert an array which has elements of different formats( like date, float and int) into MySQL table in a database using Python? I am very new to programming so please excuse me if I have made any simple mistakes

This is the code I've been trying :

```
f=open('xyz.txt')
d=f.readlines()
y=[x.split() for x in d]
print y
import MySQLdb
db = MySQLdb.connect(host="localhost",user='root',passwd='***',db='name')
cur = db.cursor()
var_string = ','.join('%s' * len(y))
sql = "INSERT INTO table1 VALUES ('%s');" % (var_string)
cur.execute(sql,y)

```

and this is how my array looks:

[['1', '"01/01/2007"', '0', '0.000', '10.14', '0.0000', '87'], ['1', '"01/01/2007"', '1', '0.000', '10.93', '0.0000', '87'], ['1', '"01/01/2007"', '2', '0.000', '11.78', '0.2540', '89'], ['1', '"01/01/2007"', '3', '0.000', '13.23', '0.5080', '90'], ['1', '"01/01/2007"', '4', '0.000', '14.43', '0.0000', '89'], ['1', '"01/01/2007"', '5', '0.000', '14.89', '0.0000', '88']]