1
Today while doing an appointment by Phpmyadmin of the type
SELECT * FROM tabela
, I noticed that after making a query in the database automatically the query gets the LIMIT
, in this way SELECT * FROM tabela LIMIT 0 , 30
, that is if I’m correct, it starts with the first record and shows 30 results. That intrigued me, because in PHP
I make these querys and send everything to a table, but what if for a year I make more than 100 entries and want to see them all? i can never predict the limit of it. In php I thought to use a variable for the limit, which received the COUNT
of all table records, or make a subquery of the type SELECT * FROM TABELA LIMIT (SELECT COUNT(*) FROM TABELA)
. I’m just looking for methods that might help in the future.
I guess that’s it PHP script paging
– rray
In fact I still don’t understand what your doubt is. It seems that you are simply making statements. Yes, Phpmyadmin limits the data, but if you determine the "limit" in the query, this is changed. Yes, if you enter 100 data you will see only 30 (if you just click on the table) of Phpmyadmin, but nothing that prevents you from using the
LIMIT
specific in your query.– Wallace Maxters
Also did not understand the doubt. From what I understand you are using a standard Phpmyadmin web query.
– Gustavo Emmel
My question is, basically, if it were you on a website that you did, what would you do to expose in a table more than 100 data. Knowing that, you wouldn’t
– programmer2016