My query isn’t coming back as backfilling the NULL spaces in description. I assume the value s/b NULL. My script looks correct, why isn’t it working? Bug??
ALTER TABLE parts ALTER COLUMN code SET NOT NULL; ALTER TABLE parts ADD UNIQUE(code); UPDATE parts SET description = 'None Available' WHERE description IS NULL; ALTER TABLE parts ALTER COLUMN description SET NOT NULL; SELECT * FROM parts limit 10;
I’m expecting the blank cells on line 3 and 9 to be filled with ‘None Available’.