Skip to content Skip to sidebar Skip to footer
Home / Mysql / Sql Server

Convert Mssql Query To Mysql Query

Post a Comment
I have the following mssql query that I found on the net that is supposed to help me with a complex mysql query that I have been struggling with for a few days now. SELECT inv.

Solution 1:

'Recommendation: extract the data out of you MySQL database in a delimited file (csv) using the utf8 (unicode) character set. Import into SQL Server using bcp specifying utf8 with "-Jutf8" parameter and character mode "-c".' See this site. Also, there's a nice tool for this.

Solution 2:

Those subqueries with FOR XML PATH('') seem to be used to concatenate strings1. See if you can replace them with GROUP_CONCAT in MySQL. The other bits seem to be standard SQL.

Post a Comment for "Convert Mssql Query To Mysql Query"