INSERT INTO world SELECT * FROM national; PB
----- Original Message ----- From: tommie ramirez.andujar To: [EMAIL PROTECTED] Sent: Saturday, May 29, 2004 2:13 PM Subject: Transfer records from one table to another Hi,, I have database about national historical events and another one about world events.. Here's the structure: National events (d: day m: month a: year hecho: fact) |-----------------------------------------------------------| | id | d | m | a |hecho | |-----------------------------------------------------------| World events (d: day m: month y: year event: fact) |-----------------------------------------------------------| | id | d | m | y | event | |-----------------------------------------------------------| Now, I want to copy the records from National to World events, is it possible? Yours tommie ___________________________________________ msc. tomas alberto ramirez.andujar webmaster - cejisoft - +5332 262451 /261410 universidad pedagogica jose marti. camaguey circunvalacion norte km 51/2 cp 74670. cuba [EMAIL PROTECTED] - www.esicm.cu/cejisoft ............................................................ Este mensaje ha sido analizado por MDaemon Antivirus v2.21. Instituto Superior Pedagógico de Camaguey, Cuba. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
