how to limit the number of records mysql produces

how to limit the number of records mysql produces

there is a very simple method to limit the number of records mysql produce

at the end of your sql statement you simply add "LIMIT 100" where 100 is the number of records you wish to show.

if you want to start from a certain record you just add "LIMIT 30, 100"

where 30 is the record number you want to start from and 100 is the number of rows to show.

 


CAN YOU HELP


Turbo Charge your business

We put our money where our mouth is. Our mission is to help any business anywhere get back on track.

If we don't bring you new customers you pay us nothing. We take nothing up front and there is no contract. We trust you implicitly. And it is literally if you don't pay us for bringing in new customers, then we stop brining them in.

You decide how much you are willing to pay for a customer and you pay once we bring them to you.

Simple, easy nothing else to explain.

If you would like us to help you get your business or products booming email us at zigzads@gmail.com

Speak soon.