Tag: add a column with a default value to an existing table

For inserting a new field in an existing table, use the ALTER statement. The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. To add a new column to an existing table, use the  ADD COLUMN statement. Syntax Specify the name of the table that