Jump to content


Photo

How to add data to a certain column


  • Please log in to reply
3 replies to this topic

#1 OriginalSunny

OriginalSunny
  • Members
  • PipPipPip
  • Advanced Member
  • 95 posts

Posted 14 February 2006 - 09:22 PM

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.

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 14 February 2006 - 10:06 PM

What you want is an update statement; try:

update products set type="cards" where id="223";

Hope that helps.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 OriginalSunny

OriginalSunny
  • Members
  • PipPipPip
  • Advanced Member
  • 95 posts

Posted 15 February 2006 - 12:03 PM

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 ??

#4 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 15 February 2006 - 12:34 PM

UPDATE products SET type="" WHERE id=1




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users