phpMyAdmin - Export Query Results

software development

#1

I’ve used phpMyAdmin to export table contents and table structures to txt and csv files with no problem. Now I want to export the results of different queries, but I don’t see any options that seem to allow that. Does anyone know if this is even possible?


#2

AFAIK this cannot be done directly in PHPMyAdmin.

  1. Create a table to contain the query results.
  2. Use INSERT INTO table SELECT ...3. Use PHPMyAdmin to export the table.

:cool: [color=#6600CC]Atropos[/color] | openvein.org


#3

Thank you for the confirmation, I thought I must be missing something. I considered that as a workaround, but was hoping for something more dynamic, as the query output may change with each use. :slight_smile:

Thanks again for the quick response!