<\/span><\/h2>\nTo add a column with a default value to an existing table in MySQL, you can utilize the `ALTER TABLE` statement along with the `ADD COLUMN` clause. The syntax for adding a column with a default value is as follows:<\/p>\n
“`sql
\nALTER TABLE table_name
\nADD COLUMN column_name data_type DEFAULT default_value;
\n“`<\/p>\n
Let’s break down the syntax to understand it better:<\/p>\n
– `ALTER TABLE table_name`: Specifies the name of the table to which you want to add a column.
\n– `ADD COLUMN column_name`: Specifies the name of the new column you want to add.
\n– `data_type`: Specifies the data type for the new column.
\n– `DEFAULT default_value`: Specifies the default value you want to assign to the new column.<\/p>\n
Here’s an example that demonstrates adding a column named `country` with a default value of ‘USA’ to a table named `customers`:<\/p>\n
“`sql
\nALTER TABLE customers
\nADD COLUMN country VARCHAR(50) DEFAULT ‘USA’;
\n“`<\/p>\n
After executing this SQL query, the column `country` will be added to the `customers` table with the data type `VARCHAR(50)` and a default value of ‘USA’. If you do not specify a value when inserting a new row, the default value will be used.<\/p>\n
How to add a column with default value in MySQL?<\/b>
\nTo add a column with a default value in MySQL, use the following SQL syntax: ALTER TABLE table_name ADD COLUMN column_name data_type DEFAULT default_value;<\/p>\n