OriginalSunny Posted February 14, 2006 Share Posted February 14, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/3429-how-to-add-data-to-a-certain-column/ Share on other sites More sharing options...
fenway Posted February 14, 2006 Share Posted February 14, 2006 What you want is an update statement; try:[code]update products set type="cards" where id="223";[/code]Hope that helps. Quote Link to comment https://forums.phpfreaks.com/topic/3429-how-to-add-data-to-a-certain-column/#findComment-11739 Share on other sites More sharing options...
OriginalSunny Posted February 15, 2006 Author Share Posted February 15, 2006 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 ?? Quote Link to comment https://forums.phpfreaks.com/topic/3429-how-to-add-data-to-a-certain-column/#findComment-11762 Share on other sites More sharing options...
wickning1 Posted February 15, 2006 Share Posted February 15, 2006 UPDATE products SET type="" WHERE id=1 Quote Link to comment https://forums.phpfreaks.com/topic/3429-how-to-add-data-to-a-certain-column/#findComment-11765 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.