SQLX (SQL-XML) Support

Dear all, I'm migrating a db grom Oracle 9ir2 to mysql 5.0. The data migrates smoothly. Some queries in my Legacy database have been developed using SQLX standard. I do not dare to hope that mySQL will (let alone does) support SQLX. Is there a way to work something out ( a layer on top of Conn

Re: Native XML Support

> > >>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? > > > > > >

Re: Native XML Support

Scott Klarenbach <[EMAIL PROTECTED]> writes: > 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? MyXML is supposed

Re: Native XML Support

Martijn Tonies wrote: > >>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? > > > "nati

Re: Native XML Support

> 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 fu

Native XML Support

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? Thanks. Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re[2]: XML support for MySQL

Jeremy, Prasad, > On Mon, Oct 13, 2003 at 11:45:33PM -0600, Prasad Budim Ram wrote: >> Is it possible to direct xml support for queryiing a SQL statement and >> get the result in also in xml? > Nope. At least, you can start the MySQL client program with an option so that it o

RE: XML support for MySQL

Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] -->Sent: Friday, October 24, 2003 1:17 AM -->To: Prasad Budim Ram -->Cc: [EMAIL PROTECTED] -->Subje

Re: XML support for MySQL

On Mon, Oct 13, 2003 at 11:45:33PM -0600, Prasad Budim Ram wrote: > Is it possible to direct xml support for queryiing a SQL statement and > get the result in also in xml? Nope. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy

Re: XML support for MySQL

I dont know about going in, but i wonder if there is an extension module to do this for you. I currently have to use a class i built to extra the xml from a query in php :\ > Is it possible to direct xml support for queryiing a SQL statement and > get the result in also in xml? >

XML support for MySQL

Is it possible to direct xml support for queryiing a SQL statement and get the result in also in xml? Prasad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: XML support in MySQL

Hello udayashankarl_n, Thursday, January 03, 2002, 4:12:11 PM, you wrote: There is no mechanism to manage it alike to SQL , for it needs many knowledge such as schema discovery for semi-stru data and so on , and it is more complex . -- Best regards, isp01ljlm

XML support in MySQL

Hi! Is it possible to load,retrieve,query data from MySQL thru XML data structures? I've gone thru the MySQL manual but, no mention of it. Please point me to the right direction. Uday - Before posting, please check: http://www

RE: XML support

1 8:14 PM > To: [EMAIL PROTECTED] > Subject: XML support > > > When will mysql support XML with function same as Oracle XSU? > > Kenneth. > > > - > Before posting, please check: >http:/

XML support

When will mysql support XML with function same as Oracle XSU? Kenneth. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this t

Re: XML Support

Gary Huntress wrote: > > In the past few days 3 different people have asked me about "xml support" in > mysql. I was unsure what to tell them actually, beyond saying "you can > easily export recordsets to xml documents".Obviously you can store > entire XML

Re: XML Support

Gary Huntress ([EMAIL PROTECTED]) writes: > In the past few days 3 different people have asked me about "xml support" in > mysql. I was unsure what to tell them actually, beyond saying "you can > easily export recordsets to xml documents".Obviously you can stor

Re: XML Support

Gary Huntress writes: > In the past few days 3 different people have asked me about "xml support" in > mysql. I was unsure what to tell them actually, beyond saying "you can > easily export recordsets to xml documents".Obviously you can store > entire XML do

XML Support

In the past few days 3 different people have asked me about "xml support" in mysql. I was unsure what to tell them actually, beyond saying "you can easily export recordsets to xml documents".Obviously you can store entire XML documents in a TEXT field, but I'm

Re: xml support?

TECTED]> Sent: Thursday, May 31, 2001 7:40 AM Subject: xml support? > Hi, > > I am trying to find out whether mysql has any support for xml? Can anyone > help me please? Please cc replies to [EMAIL PROTECTED] > <

Re: xml support?

. You can store and retrieve text with MySQL, so it's logical to assume you can do the same with XML. (There have been long discussions on this list in the past about what "XML support" for MySQL means. I suggest you have a look at the archives.) Jeremy -- Jeremy D. Zawodny,

xml support?

Hi, I am trying to find out whether mysql has any support for xml? Can anyone help me please? Please cc replies to [EMAIL PROTECTED] Thanks for any help Steve - Before posting, please check: ht

Re: XML support under mySQL

On Tue, Feb 27, 2001 at 01:21:52AM +, Peter Skipworth wrote: > > How is this superior to SQL? > > It includes the letters "XML", which, apparantly, can do everything from > butter your toast to giving you an orgasm like no other you've had > before. Don't you just *love* buzzwords! > > Sorry

Re: XML support under mySQL (Long rant)

From: "Florian G. Pflug" <[EMAIL PROTECTED]> Sent: Tuesday, February 27, 2001 1:31 AM > I think XML support should not be just "sending the respone of an > SQL-Queries written in a weird way as an XML Document as another weird XML > Document to the client". &g

RE: XML support under mySQL

2001 12:58 AM To: Cal Evans Cc: Ed Carp; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML support under mySQL Cal, Cal Evans wrote: > > Glorious Sunday morning greetings to you Jan, > > No, XML is a format for 2 different applications, usually 2 totally separate > applications

RE: XML support under mySQL

From: Florian G. Pflug [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 7:10 PM To: Cal Evans Cc: Florian G. Pflug; Juergen Fey; [EMAIL PROTECTED] Subject: Re: XML support under mySQL On Mon, Feb 26, 2001 at 06:50:27PM -0600, Cal Evans wrote: > How is this superior to SQL? Why replace a

Re: XML support under mySQL

Re: > Because it _might_ be the great, stable and matura language for > storing and querying data of tomorrow.. I think not. XML is a standard being pushed by a few big corporations, but lacks serious grassroots development, or even adequate support from recent browser versions. PHP, on the

Re: XML support under mySQL

mplement client applications which request data from a centralized server, stuff like that. XML is a formal set of rules for adding meta-data tags to character data. The reason not to "add XML support to Mysql" is THAT THERE IS NO CONNECTION BETWEEN THESE 2 CONCEPTS! A relational database is

Re: XML support under mySQL

; -Original Message- > > From: Florian G. Pflug [mailto:[EMAIL PROTECTED]] > > Sent: Monday, February 26, 2001 6:31 PM > > To: Juergen Fey > > Cc: [EMAIL PROTECTED] > > Subject: Re: XML support under mySQL > > > > > > On Sat, Feb 24, 2001 a

RE: XML support under mySQL

> From: Florian G. Pflug [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 26, 2001 6:31 PM > To: Juergen Fey > Cc: [EMAIL PROTECTED] > Subject: Re: XML support under mySQL > > > On Sat, Feb 24, 2001 at 12:50:13PM +0100, Juergen Fey wrote: > > Adding XML sup

Re: XML support under mySQL

On Mon, Feb 26, 2001 at 06:50:27PM -0600, Cal Evans wrote: > How is this superior to SQL? Why replace a great, stable and mature > language for querying databases with a verbose one? Because it _might_ be the great, stable and matura language for storing and querying data of tomorrow.. By

RE: XML support under mySQL

PROTECTED]] Sent: Monday, February 26, 2001 6:31 PM To: Juergen Fey Cc: [EMAIL PROTECTED] Subject: Re: XML support under mySQL On Sat, Feb 24, 2001 at 12:50:13PM +0100, Juergen Fey wrote: > Adding XML support to mySQL is no big deal if your`re talking about very > structured data sets like > &

Re: XML support under mySQL

On Sat, Feb 24, 2001 at 12:50:13PM +0100, Juergen Fey wrote: > Adding XML support to mySQL is no big deal if your`re talking about very > structured data sets like > > > Joe > Montana > not bad at all > > > If you got to handle a lot of these, than its eas

Re: XML support under mySQL

On Sun, Feb 25, 2001 at 10:37:10AM -0600, Cal Evans wrote: > Glorious Sunday morning greetings to you Jan, > > No, XML is a format for 2 different applications, usually 2 totally separate > applications, to be able to exchange data. It is not an appropriate choice > for storing large amounts of d

Re: XML support under mySQL

; From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jan Dvorak > Sent: Sunday, February 25, 2001 10:13 AM > To: Ed Carp > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: XML support under mySQL > > Ed Carp wrote: > > > > Gorjan Todorovski ([EMAIL PR

Re: XML support under mySQL

Michael, > Is anybody on this thread really rationally suggesting using XML > instead of SQL? I hope not. It would no longer be an SQL database. Of > course SQL is the language for committing data to the storage > mechanism. What the data consists of is another matter. I'm suggesting there is a

RE: XML support under mySQL

At 10:37 AM -0600 2/25/01, Cal Evans wrote: >Glorious Sunday morning greetings to you Jan, > >No, XML is a format for 2 different applications, usually 2 totally separate >applications, to be able to exchange data. It is not an appropriate choice >for storing large amounts of data that will have t

RE: XML support under mySQL

EMAIL PROTECTED]]On Behalf Of Jan Dvorak Sent: Sunday, February 25, 2001 10:13 AM To: Ed Carp Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML support under mySQL Ed Carp wrote: > > Gorjan Todorovski ([EMAIL PROTECTED]) writes: > > > Since XML is a way to exchange data.

Re: XML support under mySQL

Ed Carp wrote: > > Gorjan Todorovski ([EMAIL PROTECTED]) writes: > > > Since XML is a way to exchange data...and it is protocol/platform indepdnent > > there is a very good reason to have XML docuemts going in and out the > > No, it's not. You store *data* in a database, *not* metadata. Do yo

AW: XML support under mySQL

Hi, Adding XML support to mySQL is no big deal if your`re talking about very structured data sets like Joe Montana not bad at all If you got to handle a lot of these, than its easy to write an external XML I/O filter which even could handle the attributes. The result would be a simple

Re: XML support under mySQL

I agree with Jeremy and Colin. Its one thing to add functionalities, in terms of modules and interfaces, but adding to the core program is limited in it practicality, because it will just slow down execution or load-time or both. This penalizes users who don't happen to need the capabilities t

Re: XML support under mySQL

On Fri, Feb 23, 2001 at 08:26:08AM +0100, Gorjan Todorovski wrote: > > To Ed: Why be so negative about adding new features to the DB > server? Why not make things easier and make the DB more flexible by > supporting more standards for TRANSPORTING data. I'm not Ed, but... The answer is simple: i

Re: XML support under mySQL

easier and make the DB more flexible by supporting more > standards for TRANSPORTING data. > > About the education I think that is not the problem here since the guy that > posted the thing about XML support in mySQL has Master's degree in computer > science and begins a docto

Re: XML support under mySQL

To Ed: Why be so negative about adding new features to the DB server? Why not make things easier and make the DB more flexible by supporting more standards for TRANSPORTING data. About the education I think that is not the problem here since the guy that posted the thing about XML support in

Re: XML support under mySQL

Jim Gillaspy @ bellsouth.net ([EMAIL PROTECTED]) writes: > Actually, in a relational database, you do store metadata in the database, > along with the data it describes. Huh? Can you be more explicit? Maybe I'm not understanding what you're saying here... -- Ed Carp, N7EKG [EMAIL PROT

Re: RE: RE: XML support under mySQL

Cal Evans ([EMAIL PROTECTED]) writes: > Top of the morning to ya Aaron, > > 1: Ed did not suggest that everyone has to have a CS degree. Not defending > Ed because based on his posts this morning, someone pissed in his Cheerios > but he simply stated that people should be a little more educated

Re: XML support under mySQL

Actually, in a relational database, you do store metadata in the database, along with the data it describes. - Original Message - From: "Ed Carp" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, February 22, 2001 7:18 AM Subject:

Re: XML support under mySQL

Aaron Weiker wrote: > For some reason I don't think this was understood of what I said earlier. > > THE "DATABASE" ISN'T RESPONSIBLE FOR XML > > But, just because the database isn't responsible doesn't mean that the > application is responsible for generating XML. > > > to put this wrapper o

RE: RE: XML support under mySQL

Message- From: Aaron Weiker [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 8:00 AM To: 'Ed Carp'; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: RE: XML support under mySQL For some reason I don't think this was understood of what I said earlier.

RE: RE: XML support under mySQL

[mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 7:42 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: RE: XML support under mySQL Mehalick, Richard RE SSI-GRAX ([EMAIL PROTECTED]) writes: > Some relational databases return results in XML format. An

RE: XML support under mySQL

] Subject: Re: XML support under mySQL Gorjan Todorovski ([EMAIL PROTECTED]) writes: > Since XML is a way to exchange data...and it is protocol/platform indepdnent > there is a very good reason to have XML docuemts going in and out the No, it's not. You store *data* in a database, *no

Re: XML support under mySQL

Gorjan Todorovski ([EMAIL PROTECTED]) writes: > Since XML is a way to exchange data...and it is protocol/platform indepdnent > there is a very good reason to have XML docuemts going in and out the No, it's not. You store *data* in a database, *not* metadata. Do you understand the difference?

Re: XML support under mySQL

> > > XML will become a common and powerful way to express/exchange data > > > on the web. I hope MySQL decides to go along for the ride. > > > > This is all fine and good, but why does MySQL itself have to do this? > > > We don't want Microsoft and Oracle to take over the world, do we? :) The

Re: RE: XML support under mySQL

Mehalick, Richard RE SSI-GRAX ([EMAIL PROTECTED]) writes: > Some relational databases return results in XML format. And operating systems have been written in Java and Perl. So? Just because you *can* doesn't mean you *should*. Suppose I want to translate the output to something else. Now I

RE: XML support under mySQL

*big snip* I agree with Cal, the XML module should really be sperated from the RDMB. XML is really great but, lets face it not everyone is going to use it so why force it down thier troat?. The really great thing about Open Source is that you do have a choice (unlike MS , Oracle). :) You have to

Re: XML support under mySQL

Since XML is a way to exchange data...and it is protocol/platform indepdnent there is a very good reason to have XML docuemts going in and out the database. For example the database server can offer HTTP services, so we don't need stuff like JDBC/ODBC and all that. It can be done through HTTP, the

Re: XML support under mySQL

On Wed, Feb 21, 2001 at 05:22:31PM -0500, Michael Bacarella wrote: > > > > XML will become a common and powerful way to express/exchange data > > > > on the web. I hope MySQL decides to go along for the ride. > > > > > > This is all fine and good, but why does MySQL itself have to do this? > > >

RE: XML support under mySQL

keep MySQL just blindingly fast. MySQL will not be trivialized simply because it does not bolt-on every new technology that comes along. The truly great things about the open source community is that if you really feel strongly about MySQL having XML support then you can add it in. Heck, you can pr

Re: RE: XML support under mySQL

Eric Frazier ([EMAIL PROTECTED]) writes: > One thing I want. A Java way to save a data structure and recover it later. > Easy in perl, not so easy in Java. But XML would be a great way to do it in > Java. Why Java? That's like going to a gas station and saying "I want gas specifically formul

RE: XML support under mySQL

. Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 1:20 PM To: Mehalick, Richard RE SSI-GRAX Cc: 'Ed Carp'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML support under mySQL On Wed, Feb 21, 2001 at 09:49:40AM -0600, Mehalick, Richard RE SSI-GRAX wrote: > >

Re: XML support under mySQL

For someone like my self having a tool to export via XML is bloatware, Any XML handling should be delt with in the milddleware, where it will be utilized NOT the database it self. Michael Bacarella wrote: > > > Gorjan Todorovski ([EMAIL PROTECTED]) writes: > > > > > > > Is there support for XML

Re: XML support under mySQL

> Gorjan Todorovski ([EMAIL PROTECTED]) writes: > > > Is there support for XML in mySQL? > This is a reasonable inquiry. MS-SQLSever 2k and Oracle are both implementing a lot of XML functionality in their RDBMS's. Oracle is ahead of SQLServer, I believe. Like it or not, these two RDBMS's

Re: XML support under mySQL

Jeremy D. Zawodny ([EMAIL PROTECTED]) writes: > On Wed, Feb 21, 2001 at 11:18:49AM +0100, Gorjan Todorovski wrote: > > > > By support for XML I mean that u can insert XML documents directly > > in the database, of course u need to have the table properlu craeted > > first. Also it should be possi

Re: XML support under mySQL

> > Gorjan Todorovski ([EMAIL PROTECTED]) writes: > > > > > Is there support for XML in mySQL? > XML will become a common and powerful way to express/exchange data > on the web. I hope MySQL decides to go along for the ride. This is all fine and good, but why does MySQL itself have to do this?

Re: RE: XML support under mySQL

Aaron Weiker ([EMAIL PROTECTED]) writes: > application interface. XML is this magic layer in the middle that each party No it's not. XML is simply an emerging standard to describe metadata. No magic involved. > about to get this Email). The solution would be to have this other middle > tier

Re: RE: XML support under mySQL

Mehalick, Richard RE SSI-GRAX ([EMAIL PROTECTED]) writes: > Another reason, maybe even a better one, is that XML is less database > specific. So too will be the data. So the result of a query is no longer > tied to the database that produced it. Untrue. Data is data. The result of a query sh

RE: XML support under mySQL

One thing I want. A Java way to save a data structure and recover it later. Easy in perl, not so easy in Java. But XML would be a great way to do it in Java. Eric At 10:42 AM 2/22/01 +1000, Opec Kemp \( Ozemail \) wrote: >*big snip* > >I agree with Cal, the XML module should really be sperat

Re: XML support under mySQL

Doug Poland ([EMAIL PROTECTED]) writes: > > Why would it be easier to write said layer if it was inside the DBMS > > instead of outside? > > > Speed is the reason to have it in the RDBMS. It doesn't belong in MySQL. By that logic, monolithic kernels are a Good Thing. > My point is that XML is

Re: XML support under mySQL

On Wed, Feb 21, 2001 at 09:49:40AM -0600, Mehalick, Richard RE SSI-GRAX wrote: > > Some relational databases return results in XML format. The *database* does that, or an add-on query tool does that? It'd be trivial to implement an add-on for mysql (xmlmysql, a command-line tool maybe) which wou

RE: XML support under mySQL

] - -Original Message- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 2:48 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML support under mySQL Gorjan Todorovski ([EMAIL PROTECTED]) writes: > Is there support for XML in mySQL?

Re: XML support under mySQL

On Wed, Feb 21, 2001 at 01:26:56PM -0500, Michael Bacarella wrote: > > > > > > Gorjan Todorovski ([EMAIL PROTECTED]) writes: > > > > > > > Is there support for XML in mySQL? > > > XML will become a common and powerful way to express/exchange data > > on the web. I hope MySQL decides to go along

Re: XML support under mySQL

y, February 21, 2001 1:20 PM > To: Mehalick, Richard RE SSI-GRAX > Cc: 'Ed Carp'; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: XML support under mySQL > > On Wed, Feb 21, 2001 at 09:49:40AM -0600, Mehalick, Richard RE SSI-GRAX > wrote: > > > > Some r

RE: XML support under mySQL

web search: http://www.allthesites.com -Original Message- From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 2:18 PM To: Gorjan Todorovski Cc: [EMAIL PROTECTED] Subject: Re: XML support under mySQL On Wed, Feb 21, 2001 at 11:18:49AM +0100, Go

Re: XML support under mySQL

On Wed, Feb 21, 2001 at 11:18:49AM +0100, Gorjan Todorovski wrote: > > By support for XML I mean that u can insert XML documents directly > in the database, of course u need to have the table properlu craeted > first. Also it should be possible to retreive data in XML format > from some table. Thi

XML support under mySQL

Is there support for XML in mySQL? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To

Re: XML support under mySQL

By support for XML I mean that u can insert XML documents directly in the database, of course u need to have the table properlu craeted first. Also it should be possible to retreive data in XML format from some table. This is supported in Oracle 8i for eaxmple "Jeremy D. Zawodny" wrote: >

Re: XML support under mySQL

Gorjan Todorovski ([EMAIL PROTECTED]) writes: > Is there support for XML in mySQL? No la comprende, senor - XML is a markup language, MySQL is a database. What does ne have to do with the other? -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com

Re: XML support under mySQL

On Wed, Feb 21, 2001 at 09:38:23AM +0100, Gorjan Todorovski wrote: > > Is there support for XML in mySQL? What does your question mean? XML is about representing data in a structured and easily interchanged fashion. MySQL is all about *storing* and *retrieving* data which is stored in a normali

Re: XML support under mySQL

i" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 21, 2001 9:38 AM Subject: XML support under mySQL Is there support for XML in mySQL? - Before posting, please check: http://www.mysql.c