Jump to content


Photo

Updating a table?


  • Please log in to reply
4 replies to this topic

#1 Liquid Fire

Liquid Fire
  • Members
  • PipPipPip
  • Advanced Member
  • 806 posts

Posted 04 August 2006 - 11:17 AM

hey is a question that i am think of while planning out this project i am going to be working on.  Know let say i have a databse alreayd filled with a couple hundred or even thousand entries.  if i sundenly new a new row in the table and i add it, teh old entries will aquire this new table, correct? 

#2 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 04 August 2006 - 11:28 AM

That makes no sense at all.

Do you mean you 'suddenly' want a new column added to an existing table?
Legend has it that reading the manual never killed anyone.
My site

#3 tvdhoff

tvdhoff
  • Members
  • PipPip
  • Member
  • 16 posts

Posted 04 August 2006 - 11:40 AM

If you mean to say what Andy writes, then yes, all old rows will have that new column as well.

Why would you want to do such a thing, anyway?

#4 Liquid Fire

Liquid Fire
  • Members
  • PipPipPip
  • Advanced Member
  • 806 posts

Posted 04 August 2006 - 12:19 PM

yes that is what I meant.

well i am designing a project management system and with project that big i am sure i might miss a few things here and there that i will need to fix while i am coding and it would be better if i could just add a column instead recreating the whole table.  also after the first release i plan to continue working on it and well new systems that i might add may require new column on existing tables


#5 Liquid Fire

Liquid Fire
  • Members
  • PipPipPip
  • Advanced Member
  • 806 posts

Posted 04 August 2006 - 04:37 PM

also while designing i am sure that my table are going to change alittle throughout the process and again i was just making sure i can do that.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users