Last Updated: February 25, 2016
·
1.165K
· smathy

Default LIMIT for MySQL command line

Tired of adding LIMIT 10 to all your exploratory queries on the MySQL command line? Well...

SET sql_select_limit=10;

Now all your SELECTs will have that limit automatically applied. To reset it set it to DEFAULT:

SET sql_select_limit=DEFAULT;