peshopbs2

Untitled

Dec 8th, 2019
171
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. UPDATE journeys
  2. SET purpose =
  3. CASE
  4. WHEN id mod 2 = 0 THEN
  5. 'Medical'
  6. WHEN id mod 3 = 0 THEN
  7. 'Technical'
  8. WHEN id mod 5 = 0 THEN
  9. 'Educational'
  10. WHEN id mod 7 = 0 THEN
  11. 'Military'
  12. ELSE
  13. purpose
  14. END
Advertisement
Add Comment
Please, Sign In to add comment