to add a column called email to the contacts table created in create a basic mysql table with a datatype of varchar(80), use the following sql statement: alter table contacts add email varchar(60); this first statement will add the email c
to add a column called email to the contacts table created in create a basic mysql table with a datatype of varchar(80), use the following sql statement:
alter table contacts add email varchar(60);
this first statement will add the email column to the end of the table. to insert the new column after a specific column, such as name, use this statement:
alter table contacts add email varchar(60) after name;
if you want the new column to be first, use this statement:
alter table contacts add email varchar(60) first;