Subject | Re: [firebird-php] copying a table |
---|---|
Author | Milan Babuskov |
Post date | 2003-10-02T15:49:12Z |
edi_kolb wrote:
For example, with isql, you could see the table DDL with SHOW TABLE
command or -x parameter, and then write the SQL that creates identical
tables.
To fill the new table use:
INSERT INTO newtable
SELECT * FROM oldtable;
If you're only using PHP, you should install ibWebAdmin and you can
easily to the same thing from it.
--
Milan Babuskov
http://fbexport.sourceforge.net
> I´m quite new to Firebird and am using it (unwillingly) for ourWhich tool are you using to access the database?
> website. I am looking
> for a method to copy an existing table. It doesn´t matter wether
> data is copied or not
> but at least the structure should be the same. Plz give me a SQL code
> that does the
> trick!
For example, with isql, you could see the table DDL with SHOW TABLE
command or -x parameter, and then write the SQL that creates identical
tables.
To fill the new table use:
INSERT INTO newtable
SELECT * FROM oldtable;
If you're only using PHP, you should install ibWebAdmin and you can
easily to the same thing from it.
--
Milan Babuskov
http://fbexport.sourceforge.net