Last Updated: February 25, 2016
·
1.169K
· 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;

Written by Jason King

Recommend
Say Thanks
Update Notifications Off
Respond