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 achieve this, currently I am trying to use
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 released
9:06 AM Larry Martell larry.mart...@gmail.com wrote:
On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw flebber.c...@gmail.com
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
- Original Message -
From: Sayth Renshaw flebber.c...@gmail.com
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 the complexity
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 vegiv...@tuxera.be wrote:
- Original
On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw flebber.c...@gmail.com 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
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 rather hard to work with.
Indeed.
On Fri, 12 Dec 2014 9:55 PM Johan De
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 plots
approaches at the same time.
- Original Message -
From: Larry Martell larry.mart...@gmail.com
To: Steven Siebert smsi...@gmail.com
Cc: mysql mailing list mysql@lists.mysql.com
Sent: Friday, 22 November, 2013 3:17:44 PM
Subject: Re: XML to RDB
Yes, I will need to query the data, and yes
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'll be needing
-
From: Larry Martell larry.mart...@gmail.com
To: Steven Siebert smsi...@gmail.com
Cc: mysql mailing list mysql@lists.mysql.com
Sent: Friday, 22 November, 2013 3:17:44 PM
Subject: Re: XML to RDB
Yes, I will need to query the data, and yes, it's app specific to the
data.
The parent-node
of the XML
content...so your goal here is to understand how you'll be needing to
query, and build the best model (in MySQL) you can to achieve these
queries. Going back to your initial question, I don't believe there is an
organic MySQL tool (or even a 3rd party tool that I know about
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've found
many
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 larry.mart...@gmail.com wrote:
I have a need to store data that comes in an XML file in MySQL. I don't
want to store
? 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 to query the data, and yes, it's app specific to the data
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 design
the schema
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
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:
category
idsome hash id/id
titlecategory title /title
/category
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 from
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
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
...@gmail.com
To: J Trahair j.trah...@foreversoftware.co.uk
Cc: MySQL General mysql@lists.mysql.com
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 from html. See the example below.
debian76:~# mysql -h
20, 2009 3:48 PM
*Subject:* Re: Applying an XML request to a database
Yes
On Tue, Jan 20, 2009 at 7:40 PM, cr.vege...@gmail.com wrote:
Hi Krishna,
I just tried the -X and -H options as you described. Works fine.
Is it also possible to get -X or -H data from MySQL into PHP ?
TIA, Cor
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 'Bid';
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 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.
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
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, John Kebbel [EMAIL
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
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 write
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 the --xml or --html option
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 fine
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.
Thanks
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
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 List
[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-resources
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 the warning
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 the warning
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
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]
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
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] wrote
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 : I keep trying to start my car but it won't.
Tell
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. I can just
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
/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
used in lieu of databases, and at least one reference
seems to suggest that it's the superior choice. So,
before
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 of spam? Yahoo! Mail has
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 file and the server does the job.
The questions are:
a) Is it possible to do that? Somebody has tried something
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
used in lieu of databases
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 databases
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
://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, I read that XML can
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
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) What do you think about
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 must be some
- [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 Apr 2005 08:44:24 -0700
and help
Greetings
From: mathias fatene [EMAIL PROTECTED]
To: mysql@lists.mysql.com
CC: mysql@lists.mysql.com
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
fatene [EMAIL PROTECTED]
To: mysql@lists.mysql.com
CC: mysql@lists.mysql.com
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, 24 Apr 2005 12:42:26
Hi Mikel,
There are a lot of possibilities including commercial (:o)) products.
I suggest you those solutions. The output should be reparsed for your
needs :
1. the -X on client :
C:\Mysqlmysql -u mathias world -X -e desc country
?xml version=1.0?
resultset statement=desc country
Hi list, does it possible for MySQL to generate XML in the followin format:
table name=ServiceType
column name=idTipoServicio primaryKey=true
required=true type=VARCHAR size=10/
column name=nombre required=true type=VARCHAR size=255/
column name=costo required=true type=FLOAT
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
on going :-)
Kind Regards,
Thomas
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]
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# 316932703
Registered Linux User #44550
http
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
general purpose
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
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, even
[[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 any
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
RD
Tel: 0118 902 9099 (direct line)
Email: [EMAIL PROTECTED]
Web: http://www.alchemetrics.co.uk
Fabforce's DBDesigner 4 is fantastic...
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
Is there any tools or built-in functions for querying contents of a column that holds
a xml file?
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
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
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
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:
cdata/c
cdata/c
...
...
Now the problem is even if I mysql_real_escape() and
changing entities like , to lt; gt
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:
cdata/c
cdata/c
...
...
Now the problem is even if I mysql_real_escape() and
changing entities like , to lt; gt; the data
some of the characters are of ascii
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:
cdata/c
cdata/c
...
...
Now the problem is even if I mysql_real_escape() and
changing entities like , to lt; gt; the data
some of the characters
to lt; 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
format with schema like:
cdata/c
cdata/c
...
...
Now the problem
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_string()
only escapes
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 initiative
[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. Of course
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=[password] \
[-u username
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 simple. Just give
mysqldump
Is there a way to export/import MySQL tables in XML format?
Todd
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[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 General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jay -
I am not an expert with XML, however I use it with Delphi and Delphi's
TClientDataset. In this usage, I use the builtin SaveTo and LoadFrom
methods.
Todd
Jay Blanchard wrote:
[snip]
Is there a way to export/import MySQL tables in XML format?
[/snip]
Well Todd, it is a little more
Todd Cary wrote:
Is there a way to export/import MySQL tables in XML format?
trying_to_be what=funny
Yep. It's called perl :-))
/trying_to_be
Sorry 'bout that... ;-)
- Csongor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
[snip]
I am not an expert with XML, however I use it with Delphi and Delphi's
TClientDataset. In this usage, I use the builtin SaveTo and LoadFrom
methods.
[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
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
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 in array
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
1 - 100 of 281 matches
Mail list logo
