Copying a table.. or database?

[Anon]

hello! I have a problem copying a table into another table so serve as a simple back-up system. How do I this?

raul

[Anon]

Try this:

Create table new_table AS SELECT * from old_table [where ...]

If it doesn´t work
then goto:

http://www.geocrawler.com/archives/3/1/1999/7/0/2436687/

/chess

[Anon]

if u want to copy the contents of one table to another ensure that the data types of the columns belonging to both the tables are the same. u do not have to bother abt the field names.
just say
insert into a select * from b;
where a and b are tables;
u can also specify column names just like any sql stmts.

Raul wrote:

hello! I have a problem copying a table into another table so serve as a simple back-up system. How do I this?

raul