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
>
