Jump to content


Photo

Moving or copying tables


  • Please log in to reply
1 reply to this topic

#1 blanktarget

blanktarget
  • Members
  • PipPip
  • Member
  • 12 posts

Posted 05 November 2003 - 08:38 PM

I have a temp table that I use t insert listings before I insert them into the main db, so i can view them and validate them. Can I simply copy rows into other tables?
It\'s not that I don\'t know how to do it, i just haven\'t learned it yet.

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 07 November 2003 - 02:45 AM

yes.

INSERT INTO table_name SELECT * FROM another_table


Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users