i've got a table containing about 2250230 rows.
when i executed the following query on this table:
select * from my_table;
an error message returned after a long time:
mysql: Out of memory (Needed 8164 bytes)
ERROR 2008: MySQL client run out of memory
what's wrong ?
an why does it take such a long time to execute the query? can it be optimized?
thank you
when i executed the following query on this table:
select * from my_table;
an error message returned after a long time:
mysql: Out of memory (Needed 8164 bytes)
ERROR 2008: MySQL client run out of memory
what's wrong ?
an why does it take such a long time to execute the query? can it be optimized?
thank you