How to insert null value to int column in MySQL using python 2.7

Question

Trying to insert into a null value to MySql table using python. Below is the code executed

sql="""insert into db.table_name (int_column, column2) values (None, 'test')"""
cursor.execute(sql)

while running getting below error

mysql.connector.errors.ProgrammingError: 1054 (42s22) : Unknown column 'None' in 'field list'

Tried this out with reference to this solution

zealous · Accepted Answer · 2020-05-05 08:28:28Z

2

try the following, replace your none with null

sql="""insert into db.table_name (int_column, column2) values (null, 'test')"""
cursor.execute(sql)

answered May 5, 2020 at 8:28

zealous

7,5434 gold badges20 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1