I’m quite new to MYSQL. I think issue is with the
'for xml' part in the query below.
Any Help is really appreciated.
insert into AuditPolicy ( RenewalrootId , ModifiedBy, ModifiedDate, xmldata ) select par_RootId, par_ModifiedBy, NOW(3), (select * from Policy as p where p.RenewalRootId = par_RootId for XML limit 1 raw('PolicyData'),root('Policy'))
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.