Re: how to do a CPYF in SQL?

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

May I suggest that you actually try these things before coming to the 
list? That's basic netiquette in mailing list forums and newsgroups.

Make a copy of each file from the command line and try something with 
those, not the live production stuff. That's what everyone else does, 
that's how we learn - you can, too!

Fortunately or not, this is generally a friendly and helpful group. 
Still, we all have our own jobs to do. We're all much more willing to 
take time here when a questioner shows they've done some work first.

Best of the new year to you!
Vern

On 1/6/2016 9:05 AM, Hoteltravelfundotcom wrote:
> HI I would like to basically an CPYF, but in sql. This would work to create
> a copy of a file with adding all columns and data. But what I want is the
> table2 already exists, can i use this below example to copy all contents
> data into table2 from table1?
>
>
> INSERT INTO table2
> (column_name(s))
> SELECT column_name(s)
> FROM table1;