ok but each day I should udpated the table
I must use insert statement
Bruno
"Korotky Dmitry" <jedi_at_entecheco.com> wrote in message
news:aa3kmf$b9p$1_at_entecheco.com...
> "bruno nogent" <bnogent_at_club-internet.fr> сообщил/сообщила в новостях
> следующее: news:aa3jfc$t6n$1_at_s1.read.news.oleane.net...
> > I'm testing to insert into a table the datas of a select statement
> >
> > insert into mytable select ......
> >
> > but it's very very slow
> > The table to copy is : 200 lines and 50 columns
> >
> > Where is the problem ?
> >
> > Thanks
>
> You better try to use 'Create table mytable as select...'
>
> May the Force be with you!
> Jedi
>
> jedi_at_entecheco.com
>
>
>
Received on Tue Apr 23 2002 - 09:43:19 CDT
