Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
Unable to fix to MySQL script
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.×