Comments on: Multiple Inserts with a Subquery http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/ Sat, 13 Mar 2010 16:23:00 -0600 http://wordpress.org/?v=2.8.4 hourly 1 By: Insert subquery « aur1mas http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/comment-page-1/#comment-15211 Insert subquery « aur1mas Thu, 04 Mar 2010 11:43:30 +0000 http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/#comment-15211 [...] Šaltinis: http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/ [...] [...] Šaltinis: http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/ [...]

]]> By: Greg Allard http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/comment-page-1/#comment-13321 Greg Allard Wed, 07 May 2008 23:26:00 +0000 http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/#comment-13321 Yeah I guess the parenthesis weren't needed, but the result of one query (SELECT) is going to the other (INSERT) so I'd probably still call it a subquery. Yeah I guess the parenthesis weren't needed, but the result of one query (SELECT) is going to the other (INSERT) so I'd probably still call it a subquery.

]]> By: David Mathers http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/comment-page-1/#comment-13320 David Mathers Wed, 07 May 2008 22:29:14 +0000 http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/#comment-13320 That isn't a subquery (you can remove the () around the select), it's mysql syntax:<br><br><a href="http://dev.mysql.com/doc/refman/5.0/en/insert-select.html">http://dev.mysql.com/doc/refman/5.0/en/insert-s...</a> That isn't a subquery (you can remove the () around the select), it's mysql syntax:

http://dev.mysql.com/doc/refman/5.0/en/insert-s...

]]> By: Greg Allard http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/comment-page-1/#comment-2548 Greg Allard Wed, 07 May 2008 22:26:00 +0000 http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/#comment-2548 Yeah I guess the parenthesis weren't needed, but the result of one query (SELECT) is going to the other (INSERT) so I'd probably still call it a subquery. Yeah I guess the parenthesis weren’t needed, but the result of one query (SELECT) is going to the other (INSERT) so I’d probably still call it a subquery.

]]> By: David Mathers http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/comment-page-1/#comment-2540 David Mathers Wed, 07 May 2008 21:29:14 +0000 http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/#comment-2540 That isn't a subquery (you can remove the () around the select), it's mysql syntax: http://dev.mysql.com/doc/refman/5.0/en/insert-select.html That isn’t a subquery (you can remove the () around the select), it’s mysql syntax:

http://dev.mysql.com/doc/refman/5.0/en/insert-select.html

]]> By: dubayou http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/comment-page-1/#comment-13319 dubayou Thu, 20 Mar 2008 20:14:44 +0000 http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/#comment-13319 this is beautiful.<br>but damm, i can only think of the ga-zillions of scripts i need to rewrite this is beautiful.
but damm, i can only think of the ga-zillions of scripts i need to rewrite

]]> By: dubayou http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/comment-page-1/#comment-27 dubayou Thu, 20 Mar 2008 19:14:44 +0000 http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/#comment-27 this is beautiful. but damm, i can only think of the ga-zillions of scripts i need to rewrite this is beautiful.
but damm, i can only think of the ga-zillions of scripts i need to rewrite

]]>