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
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
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
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?
native xml support, now, that's probably the funniest thing
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 to help with this sort
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
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.zawodny.com
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]
--Subject: Re: 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 outputs XML:
shell 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]
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?
Prasad
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:
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,
isp01ljl
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
PROTECTED]
Subject: 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
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 store
entire XML documents in a TEXT
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 documents in a TEXT field, but I'm not sure
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 not sure thats really
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 documents in a TEXT field, but I'm not sure
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]
mailto:[EMAIL PROTECTED]
Thanks for any help
Steve
-
Before posting, please check:
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, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk
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]
mailto:[EMAIL PROTECTED]
Thanks for any help
Steve
-
Before
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...I
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".
It should make the D
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 one thing,
a set of valid XML documents is something completely
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
. 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 great, stable
: 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, to be able to exchange data
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 data
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
Player
FirstNameJoe/FirstName
LastNameMontana/LastName
Average Team="49ers"not bad at all/Average
/Player
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
Player
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
nt: 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
Player
Fi
ubject: 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
Player
FirstNameJoe/FirstName
LastNameMontana/LastName
Average T
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 you
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...and it is protocol/platform
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 to be
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
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...and it is protocol/platform
indepdnent
there is a very good reason to have XML docuemts going in and out
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
*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
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
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? :)
Their
]
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, *not* metadata
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.
And operating systems have been written in Java and Perl. So? Just becaus
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.
THE "DAT
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 u
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
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
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
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 doctorate thesis in database systems...so
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: it
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:
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
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. This is
D]; [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 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
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 for the ride.
]
-
-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
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 sperated
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
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
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 possible to
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 are
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 in
. 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:
Some relational
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
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?
We don't
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,
68 matches
Mail list logo