export query results to database limited
I want to export a fairly big amount of rows from a SQL query results to another database but the amount is limited to 5.000 rows.
My procedure is: issue query, wait for results, then click on button "export to database", choose target database.
how to avoid such limit?
请先登录再写评论。
It is not limited.
Perhaps you mean the page size?
No, I really mean the destination database only gets 5000 rows from 120000
Hm, it's not supposed to be like that. What if you export to CSV? Still 5000 rows?
Exporting to csv with no issue 1.200.000 rows
Can I ask for the screencast? It will make everything super-clear :)
Also, please, attach the SQL Log right after the import (Help | Show SQL Log...)