phpMyAdmin - Export Query Results

phpMyAdmin - Export Query Results

Posted by: ilive4iam
Posted on: 2007-03-25 15:19:00

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?

Re: phpMyAdmin - Export Query Results

Posted by: Atropos7
Posted on: 2007-03-25 18:37:00

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 Atropos | openvein.org

Re: phpMyAdmin - Export Query Results

Posted by: ilive4iam
Posted on: 2007-03-26 06:07:00

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. :)

Thanks again for the quick response!

Tags: queriesphpmyadmin