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

One Comment

Add your comments here

Back to Top