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

[mc12345678]

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

I haven't considered everything involved, but what it sounds like you want to do is create a table, and then insert into that table the results of the query. Besides that, I'm not sure what the issue is with the query, because in php you set a variable/array that equals the result.

[Ajeh]

You could try something like this:

SET @LAUNCH_DATE := '2012-01-01';
CREATE TABLE customers2012 ENGINE=MyISAM 
AS
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;

NOTE: you may or may not need the:
ENGINE=MyISAM

depending on your current tables ...