Обсуждение: copying from one table to another

I have two identical tables -- section and
temp_section.  I use the section table for keeping
original values and temp_section for editing.

How do I copy the values from temp_section to section?

=====
Weapon
__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com

Try something like:

INSERT INTO selection (fieldlist) SELECT fieldlist from temp_section;

SELECT INTO won't work, as it requires you to be creating the destination
table (well, you could drop temp_section first, but that could be annoying.)

At 11:51 PM 10/5/99, Omega Weapon wrote:
>I have two identical tables -- section and
>temp_section.  I use the section table for keeping
>original values and temp_section for editing.
>
>How do I copy the values from temp_section to section?
>
>=====
>Weapon
>__________________________________________________
>Do You Yahoo!?
>Bid and sell for free at http://auctions.yahoo.com
>
>************
>

>>>>> "OW" == Omega Weapon <weapon_77@yahoo.com> writes:

 OW> I have two identical tables -- section and
 OW> temp_section.  I use the section table for keeping
 OW> original values and temp_section for editing.

 OW> How do I copy the values from temp_section to section?

begin;

delete from section;
insert into section select * from temp_section;

commit;