MySQL Forums
Forum List  »  Docs

insert into ... select ...
Posted by: Ron Savage
Date: November 18, 2004 09:39PM

In manual for V 4.1.7, section 14.1.4.1 it says:
INSERT [LOW_PRIORITY] [IGNORE] [INTO] tbl_name [(column_list)]
SELECT ...
it doesn't actually say you can or can't select from a table in another db.
My experiments say it can't be done.
So:
insert into $t select * from other_db.$t
doesn't work.
This needs to be clarified.
And why can't it be done :-)?

Options: ReplyQuote


Subject
Views
Written By
Posted
insert into ... select ...
10903
November 18, 2004 09:39PM
4136
November 18, 2004 10:11PM
4021
January 18, 2005 12:20PM
3726
January 18, 2005 03:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.