I've figured out how to import multiple rows into one table with one
sql statement, using the syntax
Table.import columns, values
I make a list of column names, and I make a list of lists of data to
import into each column.
It works great. Inserting 100 rows in one statement appears to be
way, way faster than inserting one row at a time. But how do I do
this using a join?
I have two tables, product_lines and products. I want to import a lot
of new products at once, hopefully using the above method.
product_lines has a column called product_id, and products has a
column called id, which is a standard rails auto_increment column. I
guess I want to join the two tables, then import as described above.
How do I do this?