Guest User

Untitled

a guest
Jun 24th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. CREATE TABLE t_set (id INT NOT NULL PRIMARY KEY, value SET('one', 'two'));
  2.  
  3. INSERT
  4. INTO t_set
  5. VALUES (1, 1);
  6.  
  7. SELECT *
  8. FROM t_set;
  9.  
  10.  
  11. id value
  12. ---- ------
  13. 1 one
  14.  
  15. UPDATE t_set
  16. SET value = 0;
  17.  
  18. SELECT *
  19. FROM t_set;
  20.  
  21. id value
  22. ---- ------
  23. 1
Add Comment
Please, Sign In to add comment