Creating backup table

rwj7p · #1 (**permalink**) 10-28-02, 21:29

I am trying to create a single backup table, I am familiar with the create table function, but how do I use the function to create a duplicate table in my db.

alligatorsql.com · #2 (**permalink**) 10-29-02, 03:12

Hello,

use
CREATE TABLE mybackup AS SELECT * FROM mytab
where mybackup is the name of the backup table and mytab is the
original table.

Hope that helps ?
Manfred Peter
(Alligator Company GmbH)
http://www.alligatorsql.com

Quote:

Originally posted by rwj7p
I am trying to create a single backup table, I am familiar with the create table function, but how do I use the function to create a duplicate table in my db.

rwj7p · #3 (**permalink**) 10-29-02, 12:40

Quote:

Originally posted by alligatorsql.com
Hello,

use
CREATE TABLE mybackup AS SELECT * FROM mytab
where mybackup is the name of the backup table and mytab is the
original table.

Hope that helps ?
Manfred Peter
(Alligator Company GmbH)
http://www.alligatorsql.com

Thanks, worked just fine. I knew I was close I was trying to put the select in () thats what my issue was.

Thanks for your help

Internet Services

Web Development

Digital Marketing

Consumer Tech