Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=3065809 By: theo2005
I would like to execute a big INSERT INTO query, where a lot of records will be replicated within a table. It's in a document system and I like to generate a lot of copies of one document record. A query is much more easier for the file-admin, instead of make a lot of copies by hand in the views or making a lot of uploads of the same files. The query would be something like "INSERT INTO doc_table (column1, column2, column3) SELECT " + user_id + " AS user_id, column2, column3 FROM doc_table WHERE column2 = 'foo'" regards T. ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=55830 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
