I’m on the PostgreSQL project called " Building an Inventory Database with PostgreSQL".
For step 3, the instructions say…
partstable is missing values in the
descriptioncolumn. Alter the table so that all rows have a value for description` ."
After trying on my own AND copying and pasting the Hint which was…
UPDATE parts SET description = 'None Available' WHERE description IS NULL;
…my table still isn’t replacing null values with “None Available”. Just to be safe I made sure that they weren’t all just blank spaces so I also tried…
UPDATE parts SET description = 'None Available' WHERE description = '';
This didn’t work either. Is my syntax wrong or is this a bug?