mysql 查看表大小限制,MySQL中查询/查看表的大小限制是多少？

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.

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.

Do not cache each query result, print each row as it is received. This

may slow down the server if the output is suspended. With this option,

mysql does not use the history file.