I use this syntax but I have privilege problem. Thenk you anyway ----- Original Message ----- From: "Nitin" <[EMAIL PROTECTED]> To: "IEEIO AAOOCO" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 27, 2003 5:20 PM Subject: Re: Insert ... Select question
> of course, the syntax is: > > insert into db3.table2 (column list) select <column list> from db1.table1 > > for more information have a look at > http://www.mysql.com/doc/en/INSERT_SELECT.html > > Enjoy > Nitin > > ----- Original Message ----- > From: "ΝΙΚΟΣ ΓΑΤΣΗΣ" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, October 27, 2003 8:28 PM > Subject: Insert ... Select question > > > > Hello list > > > > I want to insert ... select data from table1 of db1 to table2 of db3. > > Is that possible? > > > > Thank in advance > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
