Jump to content


Photo

Transferring data?


  • Please log in to reply
3 replies to this topic

#1 cturner

cturner
  • Members
  • PipPipPip
  • Advanced Member
  • 148 posts
  • LocationMy computer

Posted 21 October 2006 - 03:39 AM

I am wondering how I can transfer data from one table to another? I am wanting to copy one row of data in one table and then place it in another table. Thanks in advance.

#2 corbin

corbin
  • Staff Alumni
  • Advanced Member
  • 8,129 posts

Posted 21 October 2006 - 04:43 AM

If its just an exact copy of the table theres some function for it... But if you plan to change some stuff just do

SELECT * FROM table;

then a while loop and insert it into your other table...
Why doesn't anyone ever say hi, hey, or whad up world?

#3 cturner

cturner
  • Members
  • PipPipPip
  • Advanced Member
  • 148 posts
  • LocationMy computer

Posted 21 October 2006 - 04:54 AM

How do I place a table field into another table?

#4 cturner

cturner
  • Members
  • PipPipPip
  • Advanced Member
  • 148 posts
  • LocationMy computer

Posted 21 October 2006 - 04:56 AM

Sorry I have worked out.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users