How can I insert NULL data into MySQL database with Python?

by

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

More Related Contents:

  1. mysql to pdf – python or ruby [closed]
  2. How to insert a space delimited text file into mysql using Python? [closed]
  3. Installing specific package version with pip
  4. How can I connect to MySQL in Python 3 on Windows?
  5. Python & MySql: Unicode and Encoding
  6. Authentication plugin ‘caching_sha2_password’ is not supported
  7. How to disable SQLAlchemy caching?
  8. Setting Django up to use MySQL
  9. memory-efficient built-in SqlAlchemy iterator/generator?
  10. How can I insert data into a MySQL database?
  11. How to use MySQLdb with Python and Django in OSX 10.6?
  12. When to close cursors using MySQLdb
  13. How to enable MySQL client auto re-connect with MySQLdb?
  14. How to build a flask application around an already existing database?
  15. Python MySql Insert not working
  16. What is the best solution for database connection pooling in python?
  17. Python: MySQLdb and “Library not loaded: libmysqlclient.16.dylib”
  18. How to filter (or replace) unicode characters that would take more than 3 bytes in UTF-8?
  19. trapping a MySql warning
  20. ImportError: No module named ‘MySQL’
  21. Simple Subquery with OuterRef
  22. Python JSON encoder to support datetime?
  23. Reverse engineer SQLAlchemy declarative class definition from existing MySQL database?
  24. Print results in MySQL format with Python
  25. Python’s MySqlDB not getting updated row
  26. Django + MySQL on Mac OS 10.6.2 Snow Leopard
  27. Imploding a list for use in a Python MySQL IN clause
  28. Single Django model, multiple tables?
  29. flask-login: can’t understand how it works
  30. How to disable query cache with mysql.connector

Leave a Comment