Exporting Structure and Data - Mastering phpMyAdmin 2.8 for Effective MySQL Management - page 116

author\_name & varchar(30) & Yes & \\ \hline
phone & varchar(30) & Yes & NULL \\ \hline
\end{longtable}
%
% Data: authors
%
\begin{longtable}{|l|l|l|}
\hline \endhead \hline \endfoot \hline
\caption{Content of table authors} \label{tab:authors-data} \\\hline
\multicolumn{1}{|c|}{\textbf{author\_id}} & \multicolumn{1}{|c|}{\
textbf{author\_name}} & \multicolumn{1}{|c|}{\textbf{phone}} \\ \hline \
hline \endfirsthead
\caption{Content of table authors (continued)} \\ \hline \
multicolumn{1}{|c|}{\textbf{author\_id}} & \multicolumn{1}{|c|}{\
textbf{author\_name}} & \multicolumn{1}{|c|}{\textbf{phone}} \\ \hline \
hline \endhead \endfoot
1 & John Smith & +01 445-789-1234 \\ \hline
2 & Maria Sunshine & 333-3333 \\ \hline
\end{longtable}
XML
This format is very popular nowadays for data exchange. Choosing XML in the
Export interface yields no choice for options. What follows is the output for the
authors table:
<?xml version="1.0" encoding="utf-8" ?>
<!--
-
- phpMyAdmin XML Dump
- version 2.8.2
- http://www.phpmyadmin.net
-
- Host: localhost
- Generation Time: Jul 15, 2006 at 03:44 PM
- Server version: 5.0.21
- PHP Version: 5.1.4
-->