How can I insert NULL data into MySQL database with Python?
When using mysqldb and cursor.execute()
, pass the value None
, not "NULL"
:
value = None
cursor.execute("INSERT INTO table (`column1`) VALUES (%s)", (value,))
Found the answer here
When using mysqldb and cursor.execute()
, pass the value None
, not "NULL"
:
value = None
cursor.execute("INSERT INTO table (`column1`) VALUES (%s)", (value,))
Found the answer here