How to add data to a certain column

[OriginalSunny]

Hi,

i have just added a column to a table which already contained data. I now want to fill the column with data. The only thing is i am not sure what command to use. I want to add data to the column for the rows which are already full of data. I have tried the following command but it just comes up with an error:


insert into products (type) values ("cards") where id="223";


If someone could tell me how to do it i would be greatful.

[fenway]

What you want is an update statement; try:

[code]update products set type="cards" where id="223";[/code]

Hope that helps.

[OriginalSunny]

Thanks that worked. Another quick question, how would i now remove the data in the column for the value i entered with the above command?? I have tried the following command but it doesnt seem to work?

update products drop cards where id = "1"

what should it be ??

[wickning1]

UPDATE products SET type="" WHERE id=1