Re^2: SQL Query Error

Does this database support "INSERT INTO table1 SELECT x, y, z FROM table2"? If so, you could save yourself bringing all of the data from the db into perl and back to the db and keep it all on the server. Definately much faster...

thor

Feel the white light, the light within Be your own disciple, fan the sparks of will For all of us waiting, your kingdom will come

Comment on Re^2: SQL Query Error

Replies are listed 'Best First'.
Re^3: SQL Query Error by jZed (Prior) on Sep 09, 2005 at 19:00 UTC
No, it doesn't yet support subselects with INSERT. And even when it does, it will not be any faster. Since these are CSV tables (there is no "server"), the same work is being done in my example above as would be done by INSERT with a subselect.	[reply]
Re^4: SQL Query Error by thor (Priest) on Sep 09, 2005 at 19:02 UTC
Ah...didn't see that it was using a DBD::CSV. Guess I should have looked. ;) thor `Feel the white light, the light within Be your own disciple, fan the sparks of will For all of us waiting, your kingdom will come`	[reply]