Archive for January, 2008
How to Add or Drop a column from an existing MySQL table?
Saturday, January 12th, 2008Add a column to MySQL table To add a new column col_name to the existing table table_name of VARCHAR datatype or any datatype then use ALTER TABLE as follows use the following SQL statement: ALTER TABLE table_name ADD col_name VARCHAR(size); This statement by default adds a new column at the end of ...