daily pastebin goal
82%
SHARE
TWEET

Untitled

a guest Sep 14th, 2018 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Setting value for one column of all records in table
  2. +---+-------+-----+
  3. |id |comment|likes|
  4. +-----------------+
  5. |1  |hi     |3    |
  6. |2  |hello  |12   |
  7. |3  |hey    |1    |
  8. +---+-------+-----+
  9.    
  10. +---+-------+-----+
  11. |id |comment|likes|
  12. +-----------------+
  13. |1  |hi     |     |
  14. |2  |hello  |     |
  15. |3  |hey    |     |
  16. +---+-------+-----+
  17.    
  18. update your_table set likes = null
  19.    
  20. update your_table set likes = ''
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top