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