From: Martijn Tonies
Date: August 15 2005 9:24pm
Subject: Re: Native XML Support
List-Archive: http://lists.mysql.com/mysql/187847
Message-Id: <002a01c5a1df$abab5b00$3802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

>
> >>Does MySQL 5 provide native XML support?  ie, can I have a stored
> >>procedure return an XML string instead of a recordset?  Can I pass in
> >>an XML string/doc and have the DB update relational tables based on
> >>it?
> >
> >
> > "native xml support", now, that's probably the funniest thing
> > I've heard all day :-)
> >
> > What would that actually be?
> >
> something like this I suppose
>
> http://mysql.r18.ru/~bar/myxml/XMLXpathSupportInMySQL.pdf

Nice document.

But, IMO, if you need to query elements in your XML, better
normalize the data structures and put it in tables...

That's what a database is supposed to be: tables with columns
and rows.

Use XML for what is was intended.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com