646 reputation
214
bio website noneatthemoment.de
location Germany
age 33
visits member for 2 years, 8 months
seen 7 hours ago

18h
reviewed No Action Needed SQL Server - Logical Reads lowered, Execution time remained the same
2d
comment Signal in MYSQL procedure with parameters?
I can't reproduce it. I get the message in both cases. Version is 5.6.20
2d
reviewed No Action Needed MongoDB all replica set members are “OTHER”?
2d
reviewed Reviewed Strange MySQL replication error 1146 (Table doesn't exist)
2d
comment How to Paginate a MySql Ranking Query
It's not for pagination purpose, it's for ranking. But sure, you could as well do it on application level.
Nov
24
reviewed No Action Needed debian sudo service mongod status shows failed but mongo is working
Nov
24
reviewed No Action Needed Newly created user has rights on MySQL database
Nov
24
reviewed No Action Needed Clearing log files
Nov
24
revised How to Paginate a MySql Ranking Query
formatting code for readability
Nov
24
comment How to Paginate a MySql Ranking Query
Glad I could help. Feel free to accept my answer by clicking the check, so others know the issue is solved. If you're interested, here's a quick tour on how this site works: dba.stackexchange.com/tour
Nov
24
answered How to Paginate a MySql Ranking Query
Nov
24
suggested suggested edit on How to Paginate a MySql Ranking Query
Nov
24
answered MySQL select with between optimization
Nov
22
comment How to combine two queries?
@user3637050 I have no idea what you're talking about. Your question is absolutely unclear.
Nov
21
comment Taking the difference in timestamps between successive entries
A subquery is not exactly a table. It's something "virtual". So how do you reference something you just created and that is not something "solid"? You make it "solid" by giving it a name. Imagine I would have a subquery like (SELECT 1 AS one). When the subquery has no name, how can you distinguish, if one is a column in your table or in your subquery when you select it? You can't. Therefore an alias is needed.
Nov
21
comment Taking the difference in timestamps between successive entries
Exactly. I always forget AS because it's not mandatory and I'm a lazy typer.
Nov
21
comment Taking the difference in timestamps between successive entries
var_init_query is just an alias for the subquery. Here's the documentation for variables in MySQL: dev.mysql.com/doc/refman/5.1/en/user-variables.html
Nov
21
reviewed No Action Needed Schema/Structure to handle secondary computed data
Nov
21
reviewed No Action Needed General access denied error while using import data in SSMS
Nov
21
answered Taking the difference in timestamps between successive entries