Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Table of Contents (25 chapters)
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface

Selective Exports


At various places in phpMyAdmin's interface, we can export the results that we see, or we can 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:

Note

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

Exporting and Checkboxes

Anytime we see results (when browsing or searching, for example), we can check the boxes beside the rows that we want, and use the With selected: export icon to generate a partial export file with just those rows.