How do you add a field in mysql?

10 months ago

Benjamin Taylor

1 minute

To add a field in a MySQL database, you can use the ALTER TABLE statement. Here is an example:

ALTER TABLE table_name
ADD column_name data_type;

For example, if you want to add a field named email to a table named users, you can use the following statement:

ALTER TABLE users
ADD email VARCHAR(50);

This will add a VARCHAR type field named email to the users table, with a maximum length of 50 characters. You can also specify additional data types and constraints as needed.