1) I've got a 30K row table. 2) When I run a long, 50-line query on that table, a GROUP function reduces the number of rows to 7K. 3) I want to export the grouped 7K rows as a new table, or save them as a CSV.
When I attempt to export, instead of getting the grouped 7K rows, I get the old, pre-query 30K rows.
What am I doing wrong, and what should I be doing?
NOTE: I'm not a coder, so I'd really appreciate a solution that just used the PHPMyAdmin GUI.