You are viewing fallenpegasus

entries friends calendar user info My Website Previous Previous Next Next
Mark Atwood - Thoughts while reviewing MySQL documention
12:43 pm July 31st, 2008
fallenpegasus
fallenpegasus
Add to Memories
Share
Thoughts while reviewing MySQL documention
Why may LIMIT only take a fixed number? Not even a user variable, let alone an expression.

Wouldn't it be useful to set a user session variable that always gets applied as an implicit limit value?

Both of these things could be done in Drizzle.

Tags: ,

5 comments or Leave a comment
Comments
Comment by Elf M. Sternberg
elfs From: elfs Date: July 31st, 2008 07:59 pm (UTC) (Link)
That's why they pay you the big bucks.
(Reply) (Thread)
Thread started by Harrison Fisk
From: harrison_fisk Date: July 31st, 2008 08:39 pm (UTC) (Link)
SQL_SELECT_LIMIT automatically limits results for every query on a session.

SET SQL_SELECT_LIMIT = 1;
SELECT * FROM test.tbl;
(Reply) (Thread)
supersnazz From: supersnazz Date: July 31st, 2008 08:42 pm (UTC) (Link)
That doesn't account for two-part LIMIT clauses, which is to say those with both a limit and an offset.
(Reply) (Parent) (Thread)
From: harrison_fisk Date: July 31st, 2008 08:49 pm (UTC) (Link)
Why would one want to use a session based offset/limit? I can see a definite use case for limiting all of the time, but not sure why one would want to always use an offset.
(Reply) (Parent) (Thread)
fallenpegasus From: fallenpegasus Date: August 2nd, 2008 12:40 am (UTC) (Link)
Cool, I did not know that.

Sometime I need to sit down and just read all the system variables.
(Reply) (Parent) (Thread)
5 comments or Leave a comment
profile
Mark Atwood
Name: Mark Atwood
Website: My Website
calendar
Back August 2012
1234
567891011
12131415161718
19202122232425
262728293031
page summary
tags