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 ...
10908
November 18, 2004 09:39PM
4141
November 18, 2004 10:11PM
4024
January 18, 2005 12:20PM
3733
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.