How to Insert a String in MySQL. MySQL database servers may not come with graphical administration tools, but that is the price your small business pays for free database software.

Combining Insert Statements in MySQL. The MySQL database server software, which powers many websites and business applications, uses a dialect of the industry-standard Structured Query Language ...

In MySQL it's about 4 seconds vs. about 1.5 minutes. I believe MySQL is creating a temporary table with the entire contents of the subquery where as SQL Server's optimizer is doing something smarter.