to a good
> resource for using XML with Mysql.
>
> Specifically I have a complex XML file, I would like to create a schema in
> MYSQL based on it (I have XSD as well) and be able to upload new xml data
> into the database as it's released to me.
>
> I cannot find a good way to
Hi
Hoping someone can help me work some information or direction to a good
resource for using XML with Mysql.
Specifically I have a complex XML file, I would like to create a schema in
MYSQL based on it (I have XSD as well) and be able to upload new xml data
into the database as it's rel
014 9:06 AM Larry Martell wrote:
>>
>> On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw
>> wrote:
>> > So it is definitely achievable, I see other db's converting xml2json etc
>> > to
>> > get it in.
>>
>> I use this https://github.com/hay
I see other db's converting xml2json etc
> to
> > get it in.
>
> I use this https://github.com/hay/xml2json
>
> > Sends odd that xml had done great document qualities but as a data format
> > it seems rather hard to work with.
>
> Indeed.
>
>
On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw wrote:
> So it is definitely achievable, I see other db's converting xml2json etc to
> get it in.
I use this https://github.com/hay/xml2json
> Sends odd that xml had done great document qualities but as a data format
> it seems ra
So it is definitely achievable, I see other db's converting xml2json etc to
get it in.
Sends odd that xml had done great document qualities but as a data format
it seems rather hard to work with.
Sayth
On Fri, 12 Dec 2014 9:55 PM Johan De Meersman wrote:
>
> - Origi
- Original Message -
> From: "Sayth Renshaw"
> Subject: Xml data import
>
> I have an xml data feed with xsd, it's complex in elements not size. Wray
> are the best way to get data into mysql, do I have to hack with xquery?
That's going to depend on
What is the best way to manage xml data feeds with mysql?
I have an xml data feed with xsd, it's complex in elements not size. Wray
are the best way to get data into mysql, do I have to hack with xquery?
My goal is to be able create queries and send csv files out for analysis in
R and plo
On Mon, Nov 25, 2013 at 8:29 AM, Steven Siebert wrote:
> Larry,
>
>
> If that's the only type of queries you're gonna make, sounds like MySQL
> can be a good solution (from an indexing perspective, those queries will be
> fine). Basically, you would be using MySQL as
self joins on large tables. I think I will end up going with using
x/y/z.
>
> - Original Message -
> > From: "Larry Martell"
> > To: "Steven Siebert"
> > Cc: "mysql mailing list"
> > Sent: Friday, 22 November, 2013 3:17:44 PM
&g
Larry,
If that's the only type of queries you're gonna make, sounds like MySQL can
be a good solution (from an indexing perspective, those queries will be
fine). Basically, you would be using MySQL as a read-only copy of the XML
content...so your goal here is to understand how you
ng any or all of
those approaches at the same time.
- Original Message -
> From: "Larry Martell"
> To: "Steven Siebert"
> Cc: "mysql mailing list"
> Sent: Friday, 22 November, 2013 3:17:44 PM
> Subject: Re: XML to RDB
>
> Yes, I will need to
t; little about the goal of the application? Is this app specific to this
> data, or are you looking to build an app that can take any schema defined
> XML file, ingest it, and allow you to do some work with it?
>
> Why is a lob not appropriate for your needs?
>
Yes, I will need
an app that can take any schema defined
XML file, ingest it, and allow you to do some work with it?
Why is a lob not appropriate for your needs?
S
On Nov 22, 2013 7:24 AM, "Larry Martell" wrote:
> I have a need to store data that comes in an XML file in MySQL. I don't
> want
I have a need to store data that comes in an XML file in MySQL. I don't
want to store the entire file as a CBLOB, and it doesn't lend itself to
loading with Load XML. I am looking for tools that will help me create the
schema and parse and load the data. I have googled for this and I
Hi,
I have some xml data following the following DTD. It seems that it is
better to import the xml file into multiple table, for example, author
table, journal table. I read the mysql manual section on "load xml",
but I don't see how to load xml in multiple table and how to de
VTD-XML 2.9, the next generation XML Processing API for SOA and Cloud
computing, has been released. Please visit
https://sourceforge.net/projects/vtd-xml/files/ to download the latest version.
a.. Strict Conformance
a.. VTD-XML now fully conforms to XML namespace 1.0 spec
b
Version 2.8 of VTD-XML, the next generation XML parsing/indexing/Xpath lib, has
been released. Please visit https://sourceforge.net/projects/vtd-xml/files/ to
download the latest version.
a.. Expansion of Core VTD-XML API
a.. VTDGen adds support for capturing white spaces
b
This is more of an application architecture question than a mysql question.
Though I'll offer my two cents:
What are you going to do with the XML file? Write it to disk, so you can later
read it, and parse it just to get your result set back? That sounds a lot
slower than fetching it
s that i need a lot of rows the whole site (don't ask i need the
> rows really :-) )
> this is about ~4000 rows it will be loaded from mysql database in 0.3
> seconds
> my idea was to cache this rows in a xml file like for example:
>
>
> some hash id
> category titl
-
> *From:* Krishna Chandra Prajapati
> *To:* cr.vege...@gmail.com
> *Cc:* J Trahair ; MySQL
> General
> *Sent:* Tuesday, January 20, 2009 3:48 PM
> *Subject:* Re: Applying an XML request to a database
>
> Yes
>
> On Tue, Jan 20, 2009 at 7:40 PM, wrote:
>
>&g
andra Prajapati" <
> prajapat...@gmail.com>
> To: "J Trahair"
> Cc: "MySQL General"
> Sent: Tuesday, January 20, 2009 10:28 AM
> Subject: Re: Applying an XML request to a database
>
>
>
> Hi,
>>
>> You can use -X for xml and -H
Hi,
You can use -X for xml and -H from html. See the example below.
debian76:~# mysql -h 192.168.1.10 -u teen -D teen -pteen -X
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor
Hi Everyone
I am interested in how to get an XML request to query a database. I'm working
on generating the XML requests OK, I just need to know how XML meets database.
Are there any generalised pointers to begin with?
Thanks in advance
Jonathan Trahair
Has the wheel been invented??
All my image files, stored in *.psd (photoshop) or *.cr2 (canon raw files)
file extension, have an associated *.xml file that contains the metadata
relating to the image sharing the same file name. The *.xml files have been
created by Adobe bridge and/or photoshop
LOAD XML LOCAL INFILE 'test.xml' INTO TABLE bids ROWS IDENTIFIED BY '';
Above command is now valid in V6.0.3 & cleanly ingests properly
formatted XML files.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Adhiraj,
I am going to assume that the keys and values are not static. If they
are, then this is just a matter of parsing XML into key, value
combinations.
A simple, but often less than ideal way of solving a problem like this
is to use several tables:
# The entries table is the equivilant
Hi All,
I wanted to know the possible ways in which an xml document can be stored in
the mysql database. So the keys in an xml are the columns in the database
and the key values in xml go as the values for columns. I dont want to use
java if thats possible.
Thanks in advance,
Adhiraj Joshi.
Dan and Paul,
I develop at home on Ubuntu Linux and deploy at work over FreeBSD Unix
(an iMac running OS 10.4). The command line tip you suggested worked
fine on Linux, so I'm assuming that I can get it to run here at work as
well when I get the time to try it. Thanks again.
John "Another Brick
EMAIL PROTECTED]
Cc: MySQL
Subject: Re: --xml or --html output to file
Hi John -
using --xml or --html as an argument and redirecting to a file seems to
work
here. As in,
mysql -u me -psecret -D database --html -e "select * from that_table" >
~/test_file.html
HTH,
Dan
On 5/8/07, J
At 6:09 PM -0400 5/8/07, John Kebbel wrote:
When I try using the --xml or --html option with a batch file using INTO
OUTFILE 'dirpath', the --xml or --html option seems to be ignored in
favor of the tab-delimited default. (If I get rid of the INTO OUTFILE,
xml or html displays f
Hi John -
using --xml or --html as an argument and redirecting to a file seems to work
here. As in,
mysql -u me -psecret -D database --html -e "select * from that_table" >
~/test_file.html
HTH,
Dan
On 5/8/07, John Kebbel <[EMAIL PROTECTED]> wrote:
When I try using
When I try using the --xml or --html option with a batch file using INTO
OUTFILE 'dirpath', the --xml or --html option seems to be ignored in
favor of the tab-delimited default. (If I get rid of the INTO OUTFILE,
xml or html displays fine in the terminal.)
I tried using the pager to
Hi All,
Is it possible to restore the database from an XML file (
generated from mysqldump -X)?
Please provide me the syntax. (mysql database < xmlbackupfile is not
working ).
But restore is working fine with the normal backup file.
Please throw some light on it.
Tha
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
[snip]
I'm currently looking for a tool that will take XML and produce a
database
from it. Not really looking for anything in particular at this point,
just
sort of scoping around. Anyone know of such a tool?
[/snip]
MySQL kinda' has a built-in tool
http://dev.mysql.com/tech
Hi all,
I'm currently looking for a tool that will take XML and produce a database
from it. Not really looking for anything in particular at this point, just
sort of scoping around. Anyone know of such a tool?
--
Chris White
PHP Programmer/DB Sloth
Interfuel
--
MySQL General Mailing
hen i dump a table to a xml result mysqldump throw a warning:
>
> -
>
> Warning: Can't set SQL_QUOTE_SHOW_CREATE option ()
>
> -
>
> If i dump the table to a txt
When i dump a table to a xml result mysqldump throw a warning:
-
Warning: Can't set SQL_QUOTE_SHOW_CREATE option ()
-
If i dump the table to a txt result mysqldump don't throw t
"prathima rao" <[EMAIL PROTECTED]> wrote on 11/28/2005 08:14:44 AM:
> i was tring mysqldump command line for exporting data to xml format it
is
> giving an error can anyone help me with the command line syntax
>
> rao
>
>
Your post was eqivalent to : &qu
phpMyAdmin has the ability to export to XML format. If you take a look at
its code, you may see what command is used to dump to XML. Specifically, the
code for XML export is in /libraries/export/xml.php. May put you in the
right direction.
Ben
On 11/28/05, prathima rao <[EMAIL PROTECTED]>
prathima rao wrote:
> i was tring mysqldump command line for exporting data to xml format it is
> giving an error can anyone help me with the command line syntax
No -- at least not unless you provide the command you were trying
and the error message. :-)
Especially considering the syntax
i was tring mysqldump command line for exporting data to xml format it is
giving an error can anyone help me with the command line syntax
rao
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi all,
has anyone tried to export a data from a table to *.xml format
i want a front end programme to do this automatically
for example
i have a database test in which table testing exists
i want the data from that table to be exported in xml format at a click of a
button
regards
rao
Hi everyone,
I have a freeform string field in one of my tables that is xml encoded.
Basically, i can create xml tags on the fly as and when i want, and just
store the entire xml string in the field.
This eliminates the need to create a new column everytime i have a new
"datatype&qu
>
> >>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?
> >
> >
> >
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
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
> 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
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
o
far been unable to install it, apparently because my
computer has some kind of memory problem.
When I get everything sorted out, I'll have to learn
about recursive arrays, Plone, Zope, Python, XML and
ontologies. Whew!!!
__
Do You Yahoo!?
Tired
hnique called Edge
> Representation, which is discussed about halfway down
> this page:
>
> http://www.phyloinformatics.org/pdf/7.pdf
>
> Another possible guide is the Animal Diversity Web -
> http://animaldiversity.ummz.umich.edu/site/about/technology/index.html
> - whi
oinformatics.org/pdf/7.pdf
Another possible guide is the Animal Diversity Web -
http://animaldiversity.ummz.umich.edu/site/about/technology/index.html
- which uses something called Mousetrap and TaxonDB.
This is all new and very confusing to me. Making
things even more confusing, I read that XML can be
to recover and export the file
> "contents.xml" (which is part of the *.sxw zip file) 'automagically'
> to the MySql database inserting each part of the XML to their specific
> field in the database. So the users only have to write the document,
> upload the fi
Thanks for all the tips. That makes it much clearer. I
think I'll stick with PHP and MySQL and gradually
introduce a little XML if it fits in.
I just downloaded a content management system called
Plone, which is supposed to be a good choice for
hierarchical data
Hi ,
First of all it should be clear that XML is only a well organised
representation of data a mere text file.
It is not a software . U will have to append entries all by urself to
the file, and marking up suitable tags ( say the attribute of ur
relational table) .
Data will have to be extracted
MySQL is a relational database. XML is a text file.
the biggest difference is that MySQL will let you organize, sort,
match/link (joins), and otherwise manipulate the data you have. XML is
just text with tags in a heirarchy; anything other than reading it in a
text editor will take
own
this page:
http://www.phyloinformatics.org/pdf/7.pdf
Another possible guide is the Animal Diversity Web -
http://animaldiversity.ummz.umich.edu/site/about/technology/index.html
- which uses something called Mousetrap and TaxonDB.
This is all new and very confusing to me. Making
things even more confusing,
gically' to the MySql database inserting each part
of the XML to their specific field in the database. So the users only have to
write the document, upload the file and the server does the job.
The questions are:
a) Is it possible to do that? Somebody has tried something like that?.
b) Wha
Hello,
I'm just looking at implementeing the DMOZ open directory into a mysql DB, and
having had a quick look notice its in XML format.
Does anyone have any insight into go about this - is it even a good idea?(I want
to use mysql fulltext search on the data).
I'm sure there mu
To: Mikel - <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: RE: MYSQL to XML
Date: Mon, 25 Apr 2005 17:41:47 +0200
MIME-Version: 1.0
X-Originating-IP: 213.41.126.253
Received: from lists.mysql.com ([213.136.52.31]) by mc5-f35.hotmail.com
with Microsoft SMTPSVC(6.0.3790.211); Mon, 25 A
our suggestions and help
>
> Greetings
>
> >From: "mathias fatene" <[EMAIL PROTECTED]>
> >To:
> >CC:
> >Subject: RE: MYSQL to XML
> >Date: Sun, 24 Apr 2005 21:39:14 +0200
> >MIME-Version: 1.0
> >Received: from lists.mysql.com ([213.13
uggestions and help
Greetings
From: "mathias fatene" <[EMAIL PROTECTED]>
To:
CC:
Subject: RE: MYSQL to XML
Date: Sun, 24 Apr 2005 21:39:14 +0200
MIME-Version: 1.0
Received: from lists.mysql.com ([213.136.52.31]) by mc3-f23.hotmail.com
with Microsoft SMTPSVC(6.0.3790.211); Sun,
>connect($dsn,$userid, $password,{'RaiseError' => 1});
# ---
# describe country table and print it in XML format
# ---
my $table="country";
$sth = $db
Hi list, does it possible for MySQL to generate XML in the followin format:
This XML is the structure of the ServiceType table, I'll hope that you can
help me
Thnx in advanced
Greetings
P.S. Any suggestions (tools) will be appreciated
--
MySQL Ge
For now you can use two functions to work with directly stored XML
data in MySQL - EXTRACTVALUE() and UPDATEXML(). For now we're
running our database (MySQL 5.0.5dev) with more than 15'000 records
including fulltext search and it works beautiful. So Alexander keep
Hi,
Is it possible to use the LOAD DATA INFILE to load an XML file into a table?
Thanks for your help
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Patrick Marquetecken wrote:
I seems not to figure out how to import a xml file into mysql 4.x
I'm working on, Linux, help would he fine.
XML is an hierarchical format, it does not map directly to a relational
database, which has a tabular format. I don't know if there are any
gener
Hi,
I seems not to figure out how to import a xml file into mysql 4.x
I'm working on, Linux, help would he fine.
Patrick
--
"You're dead, Jim."
-- McCoy, "Amok Time," stardate 3372.7..
Fingerprint = 2792 057F C445 9486 F932 3AEA D3A3 1B0C 1059 273B
ICQ# 31693270
As long as you've only got 1 instance of Mysql and it's on the default port!
Otherwise use one of the MySQL products.
Kevin Cowley
R&D
Tel: 0118 902 9099 (direct line)
Email: [EMAIL PROTECTED]
Web: http://www.alchemetrics.co.uk
> Fabforce's DBDesigner 4 is fantastic...
*
[[snip]]
> Have you looked into using the MySQL Administrator yet? It's a GUI program
> that should do most of what you want (I know it doesn't diagram but it's
> somewhere to start). You will have to search around to find some other
> ER-based GUI administrator tools because I can't think of an
Mike Jennings <[EMAIL PROTECTED]> wrote on 01/28/2005 07:57:06 AM:
> Hello,
>
>I am looking to export a mysql database to a gui type interface.
> Basically i'm looking at a big database and I wanna dump it to a
> webpage/uml where I can add notes on what each table is and what it
> does, e
Hello,
I am looking to export a mysql database to a gui type interface.
Basically i'm looking at a big database and I wanna dump it to a
webpage/uml where I can add notes on what each table is and what it
does, even just dumping to a webpage would be fine cause i can edit
from there.
is ther
This may just sound
stupid but I am going to ask anyway.
We run a search
engine and we bring in 3+ XML feeds from other search engines Via perl and
PHP.
So we can end up with
300 results listed for EACH SEARCH. They are only valid for that ONE
SEARCH but we need to track every click
At 14:17 -0600 9/28/04, Elim Qiu wrote:
Is there any tools or built-in functions for querying contents of a
column that holds a xml file?
If you mean using something like the standard string functions, yes.
But I suspect you mean using something like XPath, in which case, no.
If you mean
Is there any tools or built-in functions for querying contents of a column that holds
a xml file?
"Joel McConaughy" <[EMAIL PROTECTED]> wrote:
> I'm trying to implement a UDF that supports xpath evaluation on a column
> using the gnome libxml2 library. The library is thread-safe EXCEPT for
> the initialization and deinitialization routines which need to be called
> on a pre-process basis. My
I'm trying to implement a UDF that supports xpath evaluation on a column
using the gnome libxml2 library. The library is thread-safe EXCEPT for
the initialization and deinitialization routines which need to be called
on a pre-process basis. My question:
1. Is there a good place (or any place??)
At 10:46 -0700 8/12/04, Karam Chand wrote:
Hello,
i have a table with a LONGBLOB column. We store some
small images in it. I want to export them in XML
format with schema like:
data
data
...
...
Now the problem is even if I mysql_real_escape() and
changing entities like <,> to < & &g
If you base64 encode your binary, it will be valid inside the xml. As far
as I know this is the accepted way to transfer binary objects using xml.
chris
-Original Message-
From: Karam Chand [mailto:[EMAIL PROTECTED]
Sent: 13 August 2004 05:09
To: Keith Ivey; [EMAIL PROTECTED]
Subject
This leads me to another question. What are the valid
ASCII characters that XML parser understands.
Are they only a-1,A-Z,0-9,., etc or some other
characters.
Regards,
Karam
--- Karam Chand <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Hmmm. I was figuring that out. mysql_escape_
< to < solves the problem in the
data?
Regards,
Karam
--- Keith Ivey <[EMAIL PROTECTED]> wrote:
> Karam Chand wrote:
>
> >i have a table with a LONGBLOB column. We store
> some
> >small images in it. I want to export them in XML
> >forma
Karam Chand wrote:
i have a table with a LONGBLOB column. We store some
small images in it. I want to export them in XML
format with schema like:
data
data
...
...
Now the problem is even if I mysql_real_escape() and
changing entities like <,> to < & > the data
some of the charact
Hello,
i have a table with a LONGBLOB column. We store some
small images in it. I want to export them in XML
format with schema like:
data
data
...
...
Now the problem is even if I mysql_real_escape() and
changing entities like <,> to < & > the data
some of the characters ar
Are there any open source (or other) to load an XML document directly to
a MySQL table or set of tables?
Any recommendations would be greatly appreciated.
Best Regards,
Boyd E. Hemphill
[EMAIL PROTECTED]
Triand, Inc.
Life is not a journey to the grave arriving safely in a well preserved
body
Is there any (easy) way to import the data created by using mysqldump
-xml ?
I'd like to use the xml feature to export from machine A, massage the
data, import into machine B
XML works well for my application's needs in terms of massaging the
data.
Thanks,
Neal Katz
Bernd Jagla wrote:
Hi everyone,
I have XML data with a corresponding DTD, and I want create the necessary tables and
load the data.
Does anyone has experience with this?
Are there any tools to help me?
Thanks for your advice.
I would use the XML module in Perl + DBD/DBI and write the loader if I
Hi everyone,
I have XML data with a corresponding DTD, and I want create the necessary tables and
load the data.
Does anyone has experience with this?
Are there any tools to help me?
Thanks for your advice.
Bernd
I poked around the docs and mailing list for a bit, and didn't see any references to
ideas/future of this? I'm not looking so much just to store xml in MySQL, obviously I
can just use a text column for that. I was more thinking along the lines of eXist and
dbXML and the XML:DB ini
On maandag 8 december 2003 14:08 Jay Blanchard told the butterflies:
> [snip]
> > Well Todd, it is a little more complex than this. How much do you
> > know about XML?
>
> In fact, exporting is quite simple. Just give
>
> > mysqldump --xml --password=[p
[snip]
> Well Todd, it is a little more complex than this. How much do
> you know about XML?
In fact, exporting is quite simple. Just give
> mysqldump --xml --password=[password] \
[-u username] \
databasename \
[tables]
A try.
On maandag 1 december 2003 15:40 Jay Blanchard told the butterflies:
> [snip]
> Is there a way to export/import MySQL tables in XML format? [/snip]
>
> Well Todd, it is a little more complex than this. How much do
> you know about XML?
In fact, exporting is quite si
> Or from my place, "It pays for me to read the docs - thoroughly". Oh!
> Docs! What are they? :-[
Or just "mysqldump --help" :p
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
h,
Dan Greene
-Original Message-
From: John Griffin [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 01, 2003 10:49 AM
To: Dan Greene; Todd Cary; Jay Blanchard
Cc: [EMAIL PROTECTED]
Subject: RE: Export in XML
Look at http://www.mysql.com/doc/en/mysql.html. The -X option
may gi
[snip]
The most guarenteed way to have a feature in a product pointed out is to
make a public statement that it's not available :)
> Look at http://www.mysql.com/doc/en/mysql.html. The -X option
> may give you what you need.
[/snip]
As always, more than one way to skin a cat.
--
MySQL General
Blanchard
Cc: [EMAIL PROTECTED]
Subject: RE: Export in XML
I think that to answer Todd's question, no there is no inherent way in MySQL to export results as XML the way that sqlserver and oracle do.
Another solution that comes to mind (if you're using java) is to write a simple class tha
t; To: Dan Greene; Todd Cary; Jay Blanchard
> Cc: [EMAIL PROTECTED]
> Subject: RE: Export in XML
>
>
> Look at http://www.mysql.com/doc/en/mysql.html. The -X option
> may give you what you need.
>
>
> -Original Message-
> From: Dan Greene [mailto:[EMAIL PROTE
Look at http://www.mysql.com/doc/en/mysql.html. The -X option may give you what you
need.
-Original Message-
From: Dan Greene [mailto:[EMAIL PROTECTED]
Sent: Monday, December 01, 2003 9:57 AM
To: Todd Cary; Jay Blanchard
Cc: [EMAIL PROTECTED]
Subject: RE: Export in XML
I think that to
I think that to answer Todd's question, no there is no inherent way in MySQL to export
results as XML the way that sqlserver and oracle do.
Another solution that comes to mind (if you're using java) is to write a simple class
that converts a result set to an array of hashmaps (row i
first part of your questionphpMyAdmin can export in XMLthe less
complex peice, in my mind...
www.phpmyadmin.net
[snip]
Is there a way to export/import MySQL tables in XML format?
[/snip]
Well Todd, it is a little more complex than this. How much do you know
about XML?
--
MySQL
1 - 100 of 299 matches
Mail list logo
