Set value to NULL in MySQL

by

Don’t put NULL inside quotes in your update statement. This should work:

UPDATE table SET field = NULL WHERE something = something

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. How to create a MySQL hierarchical recursive query?
  3. Error related to only_full_group_by when executing a query in MySql
  4. SQL split values to multiple rows
  5. How to reset AUTO_INCREMENT in MySQL
  6. How to declare a variable in MySQL?
  7. MySQL Query GROUP BY day / month / year
  8. MySQL Cannot Add Foreign Key Constraint
  9. Grouping into interval of 5 minutes within a time range
  10. SQL counting all rows instead of counting individual rows
  11. Convert timestamp to date in MySQL query
  12. Update a column value, replacing part of a string
  13. MySQL Like multiple values
  14. In MySQL, should I quote numbers or not?
  15. Matching all values in IN clause
  16. MySQL add days to a date
  17. mysql dynamic query in stored procedure
  18. Check for x consecutive days – given timestamps in database
  19. How to alter a column and change the default value?
  20. How to select one row randomly taking into account a weight?
  21. MySQL Stored Procedures not working with SELECT (basic question)
  22. MySQL query, MAX() + GROUP BY
  23. MySQL export into outfile : CSV escaping chars
  24. Simple Random Samples from a MySQL Sql database
  25. ALTER table – adding AUTOINCREMENT in MySQL
  26. sql like operator on integer
  27. MySQL Select minimum/maximum among two (or more) given values
  28. MySQL – SELECT * INTO OUTFILE LOCAL ?
  29. How do you force mysql LIKE to be case sensitive? [duplicate]
  30. ORDER BY alphabet first then follow by number

Leave a Comment