Re: Reloading a table

[Quoted] Also, depending on what you are trying to accomplish, you could

create table my_table_backup as select * from my_table;

The do either

  delete my_table;

  insert into my_table select * from my_table_backup;

OR

  drop table my_table;

  create table my_table as select * from my_table_backup;

"Michael Kelly" <miteke_at_yahoo.com> wrote in message news:11f0f8fa.0306051144.9b772bf_at_posting.google.com...
> I wish to create a .sql file I can run to reload a table. Is there a
> simple way to dump the contents of a table into an sql format file? In
> other words a series of insert statements.
>
> please respond to miteke_at_yahoo.com
Received on Fri Jun 06 2003 - 16:10:15 CEST