Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
456 views
in Technique[技术] by (71.8m points)

sql - What to use in place of 'For XML' (in MsSql) to MySQL?

I have a VIEW written in Microsoft SQL Server which has some statements like "For XML Path (' ') '... in select statement. I have to migrate this VIEW to MySQL view. In MySQL this statement is throwing error. So my question is what to use in place of For XML??

Here's a line from the actual code-:

Select .......,
Substring (select ';' + Domain.Dom as [text()] from 
(Select CD.Domaindescription + '('  + CD.Domaincode + ')' as DOM from Conf_Domain CD
 inner join 
GDA_User_Profile_Access GUPA on GUPA.Domainid = CD.Domainid and GUPA.Userprofileid = P.Userprofileid
) As Domain For XML Path (' ')),2,1000) as UPDomain,
............

How to modify it to MySQL code??

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...