| Subject | Re: [firebird-support] Transfer data between two tables |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-11-28T01:52:57Z |
At 01:46 AM 28/11/2003 +0000, you wrote:
select id, code from tableA;
commit;
hb
>Hi,insert into tableB (id, code)
>
>if I have
>
>tableA (id integer,code varchar(5))
>
>and a tableB which I need to create as
>
>tableB (id integer,code varchar(5),misc varchar(10))
>
>I want to have all data in tableA in tableB.
>
>Is there a way to do this with a single script.
select id, code from tableA;
commit;
hb