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: