Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 30 10 Older Entries

Displaying posts with tag: xml (reset)

Getting XML and HTML output.
+1 Vote Up -1Vote Down

Many people use MySQL in the console to execute a simple command, but did you know that MySQL can format the result of the query directly to XML or html?

The option -X will output the query result as XML
-H can be used to generate a HTML table containing the data.

$ mysql -X -e "select * from test" test
<?xml version="1.0"?>
 
<resultset statement="select * from test" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <row>
	<field name="test">152710</field>
  </row>
</resultset>

Output as HTML

$ mysql -H -e "select * from test" test
<table border="1">
<tbody>
<tr>
<th>test</th>
</tr>
<tr>
<td>152710</td>
</tr>
</tbody>
</table>
Linux Documentation Writer Wanted!
Employee +1 Vote Up -0Vote Down

The Oracle Linux and Virtualization Documentation Team is seeking an experienced Technical Writer
with a focus on writing documentation for the Oracle Linux product. (The MySQL Documentation Team is part of that group as well.)

Applicants should be located in either Ireland, the UK, Sweden, Norway,


  [Read more...]
Linux Documentation Writer Wanted!
Employee +0 Vote Up -0Vote Down

The Oracle Linux and Virtualization Documentation Team is seeking an experienced Technical Writer
with a focus on writing documentation for the Oracle Linux product. (The MySQL Documentation Team is part of that group as well.)

Applicants should be located in either Ireland, the UK, Sweden, Norway,


  [Read more...]
Guidelines for generating XML
+0 Vote Up -0Vote Down

Over the last little while I've come across quite a few XML feed generators written in PHP, with varying degrees of 'correctness'. Even though generating XML should be very simple, there's still quite a bit of pitfalls I feel every PHP or (insert your language)-developer should know about.

1. You are better off using an XML library

This is the first and foremost rule. Most people end up generating their xml using simple string concatenation, while there are many dedicated tools out there that really help you generate your own XML.

In PHP land the best example is XMLWriter. It is actually quite easy to use:

  •  
  • $xmlWriter = new
  •   [Read more...]
    Breaking news: SHOW INNODB STATUS ported to XML
    +1 Vote Up -1Vote Down

    If you’re like me, you’ve gotten tired of writing endless test cases for parsers that can understand the thousands of variations of text output by SHOW INNODB STATUS. I’ve decided to solve this issue once and for all by patching MySQL and InnoDB to output XML, the universal markup format, so tools can understand and manipulate it easily. Here’s a sample snippet:

    <status><![CDATA[
    =====================================
    100320 15:46:24 INNODB MONITOR OUTPUT
    =====================================
    ... text omitted, but you get the idea ...
    ]]>
    </status>

    PS: Yes, this is a late April Fool’s joke.

    Related posts:

  • Don’t forget about SHOW PROFILES It seems t
  •   [Read more...]
    Restoring XML-formatted MySQL dumps
    +1 Vote Up -0Vote Down
    EAVB_VFZUHIARHI To whom it may concern -

    The mysqldump program can be used to make logical database backups. Although the vast majority of people use it to create SQL dumps, it is possible to dump both schema structure and data in XML format. There are a few bugs (#52792, #52793) in this feature, but these are not the topic of this post.

    XML output from mysqldump

    Dumping in XML format is done with the --xml or -X option. In addition, you should use the

      [Read more...]
    Kontrollbase – revision 297 fixes Reporter-CLI “alert_22″ sub-routine
    +0 Vote Up -0Vote Down
    Quick note to let our users know that there was an XML tag closure error on the “alert_22″ subroutine in the “bin/kontroll-reporter-cli.pl” script. This does not affect the webapp portion of Kontrollbase – only reports generated via the command line reporter script. It is not a fatal error but will cause the XML file to […]
    Kontrollbase reporter XML Parser error has been fixed
    +0 Vote Up -0Vote Down
    If you have seen the following error on the Perf Report tab “Message: SimpleXMLElement::__construct()…” – it has been fixed in revision 281. This only affects alerts 11 and 12 so you might not run into it immediately. The solution is to either remove lines “586, 590, 639, 650″ from the bin/kontroll-reporter-5.0.x_linux-x86-2.0.1.pl file, or to run [...]
    RESTful PHP Web Services – reviewed
    +1 Vote Up -0Vote Down

    I’ve been using a lot of RESTful services these days and have been waiting for a good book that is dedicated to the topic. I recently received a copy of ‘RESTful PHP Web Services’, which does a successful job of outlining proven concepts in current web technology. If you want to learn the methods for creating and consuming RESTful services then you will find many examples in this book. From the architectural plans to well thought out code samples, the book covers a lot of ground in a relatively quick read.

    The first chapter gives the reader a quick introduction to RESTful services and the most common PHP frameworks in use at the time of writing. I particularly enjoyed the section on the Zend framework due to

      [Read more...]
    2nd IKS Workshop: The Web 3.0 and Open Source Semantic Search
    +0 Vote Up -0Vote Down

    Rome is a great city and it will host a bunch of great people (including me ) at November 12-13. This is when the second IKS Project workshop will take place. The goal of this workshop is to start working on an Open Source software stack that allows other Open Source projects and software vendors to leverage semantic search technologies.

    IKS is an EU-funded project with an overall budget of 8.5 million Euros. The first workshop back in May saw two dozen of bright Open Source CMS minds discussing a semantic stack in general. This time, it will also make sense for non-CMS-related Open Source projects and vendors to join.

    There

      [Read more...]
    Showing entries 1 to 10 of 30 10 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.