Re: Appending Data into a Table from Another Table in MySQL

2011-04-23 Thread Azadi Saryev
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

Re: Appending Data into a Table from Another Table in MySQL

2011-04-23 Thread Scott Williams
That did it. Thanks Azadi!   Scott From: Azadi Saryev azadi.sar...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, April 23, 2011 2:41 AM Subject: Re: Appending Data into a Table from Another Table in MySQL INSERT INTO maintable (col1, col2

Appending Data into a Table from Another Table in MySQL

2011-04-22 Thread Scott Williams
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