Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Setting value for one column of all records in table
- +---+-------+-----+
- |id |comment|likes|
- +-----------------+
- |1 |hi |3 |
- |2 |hello |12 |
- |3 |hey |1 |
- +---+-------+-----+
- +---+-------+-----+
- |id |comment|likes|
- +-----------------+
- |1 |hi | |
- |2 |hello | |
- |3 |hey | |
- +---+-------+-----+
- update your_table set likes = null
- update your_table set likes = ''
Add Comment
Please, Sign In to add comment