Jump to content

Archived

This topic is now archived and is closed to further replies.

OriginalSunny

How to add data to a certain column

Recommended Posts

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.

Share this post


Link to post
Share on other sites
What you want is an update statement; try:

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

Hope that helps.

Share this post


Link to post
Share on other sites
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 ??

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.