Sql – Fill entire SQL table column


I just added a new column in my DB which I need to propagate with a specific text value (Confirmed). Is there a simple way to apply to all my data entries so I don't have to go through all my rows and type the value in?


Best Solution

you run the statement:

UPDATE whateveryourtableis SET whateveryourcolumnis = 'whatever';