Table problem

[Tranceprofile]

 

I gues im in the wrong section of the forum.

Anyway here is my question.

 

I got a table with 2 rows and 3 coloms.

How to move/remove one row/colom without moving the other rows/coloms?

 

Thanks,

 

Mitch

[mens]

It's called ALTER, which does exactly what one would expect.

 

To remove a column named "name" from a table called "people", you would use:

ALTER TABLE `people` DROP `name`;

 

Source(s): http://dev.mysql.com/doc/refman/5.1/en/alter-table.html