How do you add columns and their content to a MySQL table?

To add a column in a MySQL table, you can use the ALTER TABLE statement. Here are the specific steps:

1. Please specify the table name and column name that you want to add.
2. You can use the ALTER TABLE statement to specify the table name, the column to be added, and the data type of the column. For example, to add a column named columnName to a table named tableName, you can use the following statement:
   ALTER TABLE tableName ADD columnName dataType;

To add content to a column, you can use the UPDATE statement. The specific steps are as follows:

1. Please specify the table name, column name, and criteria for the target row that you want to add content to.
2. Using the UPDATE statement, specify the table name and the column to be updated along with the new value. For example, to update the content of a column named ‘columnName’ to ‘newValue’ in a table named ‘tableName’ based on a specific condition, you can use the following statement:
   UPDATE tableName SET columnName = newValue WHERE condition;