Hi again, On Wed, 2004-10-13 at 10:55, fx gamoy wrote: > hello everybody, > i ve got two big tables with the same structure. > > i would like to add the second one to the first one directly without > generating a sql file. (each table is about 1 Million line) > Is it a way with an sql command? > INSERT INTO TAB1... (select * from TAB2) ???
without ... and ( ) of course. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly