Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Step 1: Add new JSON column ALTER TABLE products ADD COLUMN attrs_json JSON; -- Step 2: Migrate data UPDATE products SET attrs_json = CAST(attrs_text AS JSON) WHERE JSON_VALID(attrs_text); -- Step 3: Verify SELECT COUNT(*) FROM products WHERE attrs_json IS NULL AND attrs_text IS NOT NULL; -- Step 4: Drop old column and rename
Result
Open