Drop column MySql command used to delete a column from an existing MySQL table. Syntax for deleting particular column for the able is : ALTER TABLE tablename DROP column-name for example ALTER TABLE moviesite DROP movie_name where moviesite – Table…
Drop column MySql command used to delete a column from an existing MySQL table.
Syntax for deleting particular column for the able is :
ALTER TABLE tablename DROP column-name
for example
ALTER TABLE moviesite DROP movie_name
where
moviesite – Table name
movie_name – Column name.
I get the error message ‘No database selected’ when I try to run this command.
thanks
