INSERT INTO maintable (col1, col2, ..., colN) SELECT col1, col2, ..., colN FROM table2
Azadi On 23/04/2011 11:51 , Scott Williams wrote: > Hello geniuses! > > I've been largely successful exporting my Access database into MySQL, but > have one problem. The SQL dump file for one of my tables is just a smidge too > large to import (the host limits the size to 2048, and my sql file is 2137). > > Anyway, I just broke the table into two, Table1 and Table2. I intended to > just just append Table 2 onto Table1, but now that I'm trying to do it, I > realize that I don't know how. > > Any suggestions? > > > Scott > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm