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]
