Is the problem with your SQL? In other words, I do not think INSERT is designed
to handle multiple rows. Have you tried something more along the lines of:
INSERT INTO database1.table1 VALUES (SELECT * FROM database2.table2 WHERE ...)
in which your WHERE clause limits the select result to one row?
tim.
> Hi,
> it means, you could for example select data from one table without
> use at first of "use database..." ...
>
> ex.
> select * from database.table;
>
> I still don't know, how should I use it.
> Something like:
> insert into database1.table1 select * from database2.table2...
> doesn't work, or maybe you mean something another....
>
> regards
> jed
>
> Paul DuBois wrote:
>
> > You can access multiple databases on the same server if you qualify table
> > names as necessary with leading database names (e.g., db_name.tbl_name). You
> > can't access databases on different servers within the same statement.
> >
> > >> Hi @,
> > >> one question,
> > >>
> > >> Is there any possibility to transfer the data from one table of one
> database
> > >> to another table of another database...
> > >>
> > >> I'll try to be creativ.... :-)
> > >>
> > >> insert into database1.table1 select * from database2.table2....
> > >>
> > >> or something like this...
> > >>
> > >> Any Ideas?
> > >>
> > >> Regards
> > > > jed
