>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 ... SELECT can handle any number of rows.
>
>INSERT INTO database1.table1 VALUES (SELECT * FROM database2.table2 WHERE ...)
>
>in which your WHERE clause limits the select result to one row?
I don't think MySQL supports that syntax.
>
>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
--
Paul DuBois, paul@stripped
