Inserting values into an existing db SQL

[recset]

I have an existing table, and I want to create a new column (with a default value), and have all of the records already in the table, have the new default value and column .... what SQL statement would accomplish this?

[The Lost Faith]

ALTER TABLE db.tbl_name
ADD COLUMN col_1 [VALUES]

[recset]

Thanks for responding.

However, that doesn't work, the following statement does work:

[code]ALTER TABLE `wisdom_backup` ADD Cases2 varchar(30)[/code]

However how do I get it to show a default value for the new column????

[fenway]

add "default 'your default value'".