Save the Multi Table Query Result in phpmyadmin or by SQL CLI

[explorer1979]

Hi all,

I have a big problems of using phpmyadmin running this SQL.

SET @LAUNCH_DATE := '2012-01-01';
SELECT * FROM address_book WHERE customers_id IN (select customers_info_id FROM customers_info WHERE customers_info_date_of_last_logon < @LAUNCH_DATE)
ORDER BY `address_book`.`customers_id` DESC;

It will show result no problems, but since it is not just query data from one table, it also using customers_info as source before query the address_book.

My big problems is, while I am using phpmyadmin run above SQL, I can't full export above result to save as a SQL files for backup using.
If the SQL query just only one table, then it can export all result to a SQL files no problems, just above SQL CLI can't save it result.



Anyone there can tell me how do I can save above query result as SQL files for future using (For example, del above result, then restore it later by using this backup exported SQL files).