how do I export campared results in phpmyadmin?

Hi iahe compared two table and got results of the same. but these results are in thousands of开发者_如何转开发 pages. so how do I export the same to text.

SELECT * 
FROM Table1
WHERE username NOT 
IN (

SELECT username
FROM table2
)
LIMIT 0 , 30 

To export your query result from PHPMyAdmin

There is an block named "Query results operations" with option of Export.

Through this Export option, you will have query result exported.

Use the export option at the buttom of the page in the "Query result operations". Edit: (like @Gaurav said +1).

This will export you everything you selected with your query. (No need to click on any checkboxes)

Screenshot to clear things up: