I'm not great at SQL so this question should be very easy to answer :) I have a column titled Grades and all values are currently NULL. I would like to update the Grades column to "No Data" if it's NULL
This is what I have so far: Select (ISNULL(Grade, 'test'))
From bleaTest
Thank you in advance!!
To update table you can do this
UPDATE bleaTest
SET Grade = 'No data'
WHERE Grade is null;
And to select
Select ISNULL(Grade, 'No Data') Grade From bleaTest
ISNULL over COALESCE
This probably needs to be customized for your setup, but if you actually want to update the table it would look like
update theTable
set Grades = isnull(Grade, 'No Data')
Or alternately
update theTable
set grades = 'no data'
where grades is null
You can use the following SQL statement
UPDATE bleaTest set Grades = 'No Data' WHERE Grades IS NULL;
You can do an Update as said before:
UPDATE bleaTest SET Grades = 'No Data' WHERE Grades IS NULL;
But if you want to prevent new registers to have a NULL value in that column you can use this code to alter the table:
ALTER TABLE bleaTest MODIFY Grades NOT NULL;
ALTER TABLE bleaTest ALTER Grades SET DEFAULT 'No Data';
the code can chance depending on what database you use.
