Data generated as the result of SELECT statement can be exported to another database table.
Export result as database table
Feeling of Advanced tab when saving into new table:
Export result as text
Data generated as the result of SELECT statement can be exported to a chosen text file. If the data content contains the separator, a prompt box will appear after exporting.