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
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
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
3 matches
Mail list logo