'MySQL showing that select * from has internal limit 0,1000 . how to stop it
i am accesing my Mysql database server using Mysql workbench.and i have encountered a prolem.
there is a table, named tags, in my database.which will have have more than thousands of tags in future.the problem is when i am executing select * from tags; query Mysql workbench is executing this (or taking action) like select * from tags LIMIT 0, 1000. i am giving you a snapshot
my question is how can i stop it.because when i will launch my application it will have thousands(much more than 1000) of tags.if it implies LIMIT 0, 1000 internally then my php script wont have all the tags at the time of executing my tagging system.
all i want is to have no limits on select *.how can i do that?what will be the modified Select * query not to have any limits
Solution 1:[1]
I addition to Fluffeh's answer: you can change the limit to whatever value you want, including switching it off entirely (see the MySQL Workbench preferences).
Solution 2:[2]
Go to -> MySQL Workbench -> Edit Menu -> preferences -> SQL Editor -> Query Results -> Uncheck Limit Rows.
Solution 3:[3]
It's a little different in my case Go to -> MySQL Workbench -> Edit Menu -> preferences -> SQL Editor -> SQL Execution -> Uncheck 'Limit Rows'.
In the screenshot attached, the limit disabling checkbox can be seen.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Mike Lischke |
| Solution 2 | ABHAY JOHRI |
| Solution 3 | Umer Farooq |