Re: mysql export resultset to xml format
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: > > 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 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Ben Wilson " Mundus vult decipi, ergo decipiatur"
Re: MySQL database design documentation
Relational Database Design Clearly Explained, Second Edition ISBN: 1558608206 The original edition was my first primer on relational databases. It was an excellent read. Ben Maurice van Peursem wrote: Hi, I'm relatively new to the database-scene. I've installed MySQL on Mac OSX 10.3, which was easy. I've installed Perl support for MySQL, which was suprisingly difficult. I've installed CocoaMySQL (http://cocoamysql.sourceforge.net/) to create, inspect and backup databases. And now I'm building my first database, and that is not as easy as I had hoped. I know that use of the 'JOIN' keyword can save me pages of Perl code, but how it works exactly is not yet clear to me. Therefore I'm looking for a book, or maybe other documentation (on the web?), that can point me in the right direction. More specifically, I'm looking for a book that explains how to design and build databases, with examples of the queries in MySQL. Most books describe how you install MySQL, and list the SQL commands, but this information I already have. Can any of you suggest to me some helpful learning material? Thanks, Maurice van Peursem The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How-to Juggle Two Databases . . .
I don't know if this is the best forum to ask this question, but I thought perhaps somebody here could at least point me in the right direction. I am looking to create an application (Win32 at least). This app will need the ability to write to a central database, but also be able to pull a snapshot of that database into itself for remote (i.e., can't access the database) operation. I anticipate that the local user will modify the local copy, then sync that copy to the server. Concurrently, I anticipate other users will be modifying the server copy and/or their own local copy. The question I have is how to keep all this going without causing data loss? I mean, I can't run an auto_increment because the record numbering on the remote and server copies would be in conflict. I also am not sure of the best way to re-sync. I once was on a project where we logged all database entries, as three servers operated without being able to directly share (long story). The logging was problematic to say the least. I would say that if it were possible to have all of the functionality of a database with the version control power of CVS (or subversion), that would be ideal. Any suggestions? Regards, Ben Wilson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]