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
Add new column to tables
List Code:-
Mysql Codes
Next Code:-
Insert data into tables
Thank you
ReplyDelete