Python mysql error

[SATYANARAYANA365]

I connected python with mysql and tried to run a simple code which takes data from user and saves in mysql.

Code works fine, takes data from user but isn't saving it in database.

Error code 1054 Unknown column 'date' in 'field list'

But there is date column in table.

[sudheerdivyakolu]

I connected python with mysql and tried to run a simple code which takes data from user and saves in mysql.

Code works fine, takes data from user but isn't saving it in database.

Error code 1054 Unknown column 'date' in 'field list'

But there is date column in table.

Hi, please share the code where select statements are written

[ezimoha-obichukwu]

Do you have mysql extension installed?