How to add new column to tables in mysql with example

if you want insert extra column to tables in mysql than use this syntax

Syntax:-

ALTER TABLE table_name ADD col_name datatype(size);

Example:-

homeno	homename	state	country
206	chiguru	karnataka	india
20	krish	kerala	india

We adding new column address to homedetails table

ALTER TABLE homedetails ADD address varchar(30);

homeno	homename	state	country	address
206	chiguru	karnataka	india	NULL
20	krish	kerala	india	NULL

Previous Code:-
Auto increment column

List Code:-
Mysql Codes

Next Code:-
Delete column from tables