Default limit for SQL queries

[expired user #10164]'s profile image [expired user #10164] posted 7 years ago in General Permalink

Hello there,

Is there a way to define a default 'limit' (for example 50 or 100) to the number of results/rows when a SQL query is executed ?

Or maybe I'll just have to learn to add " limit XX" to my queries :)

thanks

ansgar's profile image ansgar posted 7 years ago Permalink

I'm afraid you have to learn that :)

Magically adding some auto-limit is something beyond HeidiSQL's features. The underlying query analyzer is just a regular expression which warns you when doing some DELETE FROM ... or UPDATE ... SET x=z without a WHERE clause.

[expired user #10164]'s profile image [expired user #10164] posted 7 years ago Permalink

Well it's fine I'll learn, thank you for your answer :)

I'm a former Mysql-Workbench user so I was used to this limit for the results.

I'll go on with HeidiSQL anyway, great job ;)

Please login to leave a reply, or register at first.