问题描述
我正在使用MySQL，目前在数据库中有3个表.我创建了一个视图表，其中包含3个表之间的关系.视图表应该是大约20万行数据，因为我也在Access中测试了相同的查询，并且工作正常，但是很遗憾，我不允许使用Access.
I am using MySQL and currently have 3 tables in a database. I created a view table with relationships between the 3 tables. The view table should be about 200 000 rows of data because i also tested the same query in Access and it works fine, but unfortunately i am not allowed to use Access.
当我在MySQL中构建视图时，我收到一条消息，指出该视图已成功构建.但是，当我尝试实际查看数据时，它给了我类似MySQL内存不足的信息.我不确定我可以做些什么来避免此消息.有人可以给点建议吗?
When i build the view in MySQL i get a message that says the view was build successfully. But when i try to actually view the data, it gives me something like, MySQL ran out of memory. I am not sure what i can do differently to avoid this message. Can someone please give some advice?
推荐答案
您可以使用快速选项，用于运行查询.
You can use the Quick option for running your query.
这篇关于MySQL中查询/查看表的大小限制是多少?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！