Add or delete columns in a table in MySQL

Add a column to a table in the database:


ALTER TABLE table_name
ADD column_name datatype

Delete a column from a table in the database:


ALTER TABLE table_name
DROP COLUMN column_name

0 Responses to “Add or delete columns in a table in MySQL”


  • No Comments

Leave a Reply