HomeDatabaseMySQLDelete a column from an existing MySQL table

Delete a column from an existing MySQL table

By Quinn McHenry

1095

The SQL command in this recipe removes a column and the column’s data from an existing MySQL table.

To delete the column col_stuff from the table table_things, use the following SQL command:

ALTER TABLE 'table_things' DROP 'col_stuff'

Previous article

Google: Focus Your Search on a Specific Geographic Location

Next article

Autorun / Autoplay an HTML file When a CD in Inserted

Quinn was one of the original co-founders of Tech-Recipes. He is currently crafting iOS applications as a senior developer at Small Planet Digital in Brooklyn, New York.

RELATED ARTICLES

LEAVE A REPLY Cancel reply

Please enter your comment!

Please enter your name here

You have entered an incorrect email address!

Please enter your email address here

Most Popular

Recent Comments

William McCoy on How To Change Thumbs Up on Facebook Messenger

Bazaarroom on 5 Great Tech Skills to Learn During Lockdown

Andrea on How Do I Make the Icons Bigger on iPhone?

Diane Gustavson on How to Enable Notification Sounds on Android

TechyList on iPhone and Android: Automatically Add a Task to a To-Do List Using Email

Ron on How to Apply Filters in Google Sheets Mobile

Khaitan on Hostinger WordPress Hosting Review: Is It a Good Fit?

Maxim Mirov on How to Get Link from Forbes for Free?

Satyam on Hide Files and Folders in Windows Using Command Prompt

Михаил on Photoshop: Change Default Unit from Inches to Pixels

error: Content is protected !!