We don’t allow questions seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. You can edit the question so it can be answered with facts and citations.
Closed 7 years ago.
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
接受
或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
发布评论
评论(2)
我不会一次性获取 300 万行。无论您使用什么客户端,机器都会阻止您获取所有行。相反,您应该批量获取行。
I wouldn't fetch 3 million rows in one go. It doesn't matter what client you use - the machine will be what's preventing you from getting all the rows. Instead, you should fetch the rows in batches.
有一些 GUI 工具。
http://www.databasejournal.com/ features/mysql/slideshows/top-10-mysql-gui-tools.html
但就像其他人所说,您必须以较小的部分获取数据。
There are some GUI tools out there.
http://www.databasejournal.com/features/mysql/slideshows/top-10-mysql-gui-tools.html
But like others said, you have to fetch the data in smaller parts.