Please support us by disabling ad blocker for smarttutorials.net ...

Delete a column from an existing MySQL table

Posted by & filed under MYSQL.

Drop column MySql command used to delete a column from an existing MySQL table.

Delete a column from an existing MySQL table

MySql Logo

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.

Download Premium Only Scripts & 80+ Demo scripts Instantly at just 1.95 USD per month + 10% discount to all Exclusive Scripts

If you want any of my script need to be customized according to your business requirement,

Please feel free to contact me [at] muni[at]smarttutorials.net

Note: But it will be charged based on your customization requirement

Get Updates, Scripts & Other Useful Resources to your Email

Join 10,000+ Happy Subscribers on feedburner. Click to Subscribe (We don't send spam)
Every Email Subsciber could have access to download 100+ demo scripts & all future scripts.

  • I get the error message ‘No database selected’ when I try to run this command.

    thanks

Get Instant Script Download Access!