UBB.Developers Forums Community Development Programming MySQL and Server Configuration MYSQL ALTER Command?

I'm not too clear on what you want to do so I'm making a guess.

I think you want to use the update command if you are just trying to change some of the data. The alter command I believe is to change the structure of the table.

So you want something like this.

UPDATE tablename SET new='no' WHERE make = 'Ford'
If by new column you mean a column that does not yet exist then you would need to create that first.
To do that you use.
ALTER TABLE tablename ADD newcolumn VARCHAR(20)

you can set it to be what ever type you want obviously.

If i have misunderstood what you are trying to do then please let me know and I will try again.

Regards

Dan