Connecting Tech Pros Worldwide Forums | Help | Site Map

Is there a MySQL alternative for the MSSQL XML datatype?

Newbie
 
Join Date: Dec 2007
Posts: 15
#1: Aug 8 '08
Is there any datatype in MYSQL which replaces XML Datatype?
XML datatype i used in stored procedure for bulk input.
Atli's Avatar
Moderator
 
Join Date: Nov 2006
Location: Iceland
Posts: 3,747
#2: Aug 16 '08

re: Is there a MySQL alternative for the MSSQL XML datatype?


Hi.

MySQL 5.0 and 5.1 do not support such a feature.
See this blog for more details on XML support in these versions.

MySQL 6, however, will provide a LOAD XML statement, which allows you to insert rows based on the data in a XML file.
Reply