Exporting selectively_Mastering phpMyAdmin 3.3.x for Effective MySQL Management-QQ阅读男生中文都市网

上QQ阅读APP看书，第一时间看更新

Exporting selectively

At various places in phpMyAdmin's interface, we can export the results that we see, or select the rows that we want to export.

Exporting partial query results

When results are displayed from phpMyAdmin (here, the results of a query asking for the books from author_id 2), an Export link appears at the bottom of the page.

Clicking on this link brings up a special export panel containing the query on the top, along with the other table export options. An export produced via this panel would contain only the data from this result set.

Note

The results of single-table queries can be exported in all of the available formats, while the results of multi-table queries can be exported only in the CSV, XML, and LaTeX formats.

Exporting and checkboxes

Any time we see the results (when browsing or searching, for example), we can check the checkboxes next to the rows that we want, and use the With selected: export icon to generate a partial export file containing just those rows: