'MYSQL Storage for Query Results

Can someone explain how does the storage works in MySQL. For example if i have a very large data set in my DB, what happens each time i give the query - SELECT * FROM option? Does querying this statement use up the memory in the drive?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source