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