tsql - 'With namespace' keyword is not working on mysql -

I have tried to use the following script which are working fine in MSSQL but not in mysql

 ; With XMLNAMESPACES (select 'http://www.ctor.com/retail' as retail), cast as XML (cast (copy (copy ([XML], 'encoding = "UTF-8"', ('Max')) as enactorem.customerattributes  

('Data' / Retail: Consumer Properties / Retail: Price / Retail: Worker (200)). Div>

as Desct) [1]