DISQUS

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

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

    ALTER TABLE table_things DROP col_stuff
  • Neelesh · 8 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 · 6 months ago
    thanks it solved problem
  • vol · 6 months ago
    ALTER TABLE table_things DROP col_stuff;
  • A · 4 months ago
    ALTER TABLE room DROP COLUMN y;