DISQUS

Tech-Recipes: Delete a column from an existing MySQL table | MySQL | Tech-Recipes

  • Thennarasu · 1 year ago
    Ya it works...
  • kiran · 1 year ago
    helpful in coding.thank u.
  • Dan · 11 months ago
    try myNet.Office
    at: www.NetthruOffice.com
  • Mercy · 11 months ago
    Thank u. It is useful
  • mysql · 11 months ago
    use it without ( ' )...
  • steve · 10 months ago
    yep:

    ALTER TABLE table_things DROP col_stuff
  • Neelesh · 9 months ago
    If we want to check whether that column exit, if exist only then delete the column so that our script does not hamper.
  • jaswath · 8 months ago
    thanks it solved problem
  • vol · 8 months ago
    ALTER TABLE table_things DROP col_stuff;
  • A · 6 months ago
    ALTER TABLE room DROP COLUMN y;
  • dennis · 1 week ago
    ALTER TABLE `article` DROP column `homepage`;

    Need to use key word column with my version of mysql. 5.1.41-1