How to delete column in tables using mysql with example

if you want drop column in mysql than use this syntax

Syntax:-

ALTER TABLE table_name DROP COLUMN col_name;

Example:-

homeno	homename	state	country	address
206	chiguru	karnataka	india	8/3 cross
20	krish	kerala	india	3rd main

Here we deleting column address in homedetails table

ALTER TABLE homedetails DROP COLUMN address;

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

Previous Code:-
Add new column to tables

List Code:-
Mysql Codes

Next Code:-
Insert data into tables