LinuxQuestions.org
Help answer threads with 0 replies.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
Reload this Page How to delete a column in MySQL ?
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 10-15-2004, 09:17 AM   #1
indian
Member
 
Registered: Aug 2004
Posts: 137

Rep: Reputation: 15
How to delete a column in MySQL ?

Hi, How to delete a column in MySQL ? I just need the command ....

With Regards...
 
Old 10-15-2004, 12:16 PM   #2
np complete
Member
 
Registered: May 2004
Distribution: Fedora Core 2/3
Posts: 51

Rep: Reputation: 15
I believe you are looking for the "Alter Table" command

or if you cannot figure that out, i would do a "select into" and then drop the original table. then rename the table if desired
 
Old 10-15-2004, 01:02 PM   #3
indian
Member
 
Registered: Aug 2004
Posts: 137

Original Poster
Rep: Reputation: 15
Thanks I got it...It is

" ALTER TABLE T1 DROP column";
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
updating a column in MySQL mohtasham1983 Programming 1 10-28-2005 10:01 AM
Unable to delete files of MySQL laguna01 Red Hat 7 10-21-2005 04:51 AM
add/delete record in mysql table on linux from a WinXp machine using visual c++ SyncMaster Linux - Enterprise 2 05-30-2005 12:53 AM
phpmyadmin (or regular mysql) batch column edit? fibbi Linux - Software 1 07-10-2004 02:06 PM
PHP/mysql delete problem crabboy Programming 1 08-10-2001 09:08 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 03:59 PM.

Contact Us - Advertising Info - Rules - Privacy - LQ Merchandise - Donations - Contributing Member - LQ Sitemap -
Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration