[Resolved] Deleting entire columns in MySQL

[Davidc316]

Does anyone know the raw MySQL commands you type in to delete and then replace entire columns in a database?

Let's say for example, I've got a column called "Price" but price is no longer important to my database so I want to remove that entire column including even the field tag of price. In it's place I want to add a new varchar column called "description" (or something like that).

Does anyone know how this is done?

I've checked these forums and the MySQL manual for the solution to this problem.

It's probably in the MySQL manual somewhere, but I searched around and I couldn't find it, so I thought I'd see if anyone knew here.

[bernouli]

ALTER TABLE table DROP Preis

ALTER TABLE database.table ADD description VARCHAR(255) NOT NULL AFTER colum_before_Preis;

[Davidc316]

Perfect!!!

Thanks very much for that!