eqeqwan21

mysql

Oct 28th, 2025
561
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.20 KB | None | 0 0
  1. ALTER TABLE `user` ADD COLUMN `dev_tokens` JSON NULL;
  2.  
  3. UPDATE `user`
  4. SET `dev_tokens` = JSON_ARRAY(`dev_token`)
  5. WHERE `dev_token` IS NOT NULL AND (`dev_tokens` IS NULL OR JSON_TYPE(`dev_tokens`) = 'NULL');
Advertisement
Add Comment
Please, Sign In to add comment