To add a new column to an existing MySQL database table, you can use the ALTER TABLE statement with the ADD COLUMN clause. Here's an example:
ALTER TABLE table_name
ADD COLUMN column_name column_definition;
Replace "table_name" with the name of the table to which you want to
add a column, "column_name" with the name of the new column, and "column_definition" with the data
type and any other properties of the new column.
For example, to add a new column called "age" to a table called
"users" with the data type INT:
ALTER TABLE users
ADD COLUMN age INT;
You can also specify other properties of the column, such as a default value
or whether it can be null, like this:
ALTER TABLE users
ADD COLUMN age INT NOT NULL DEFAULT 0;
This would add a new column called "age" to the "users" table with the data
type INT, and set a default value of 0, while also specifying that the column cannot be null.