How do you delete a table field in phpMyAdmin?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

How do you delete a table field in phpMyAdmin?

Postby Granpoh » 11. August 2008 09:44

Hello,

Well I know how to "add fields" to a table, but how do you "delete fields" from a table?

Thanks for all assistance
Granpoh
 
Posts: 39
Joined: 27. April 2008 10:23

Postby Nobbie » 11. August 2008 11:43

Either use the table view dialog and click on the red cross to delete a column (not "field", its called column), or simply enter the following command in a SQL Dialogbox:

Code: Select all
ALTER TABLE `tablename` DROP `columnname`
Nobbie
 
Posts: 8772
Joined: 09. March 2008 13:04

Postby Granpoh » 11. August 2008 12:09

I was looking all over the place for a "delete" or a "remove" option.

Thanks Nobbie.
Granpoh
 
Posts: 39
Joined: 27. April 2008 10:23


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 44 guests