341 reputation
1217
bio website coffeeplusplus.z11.de
location Germany
age 42
visits member for 2 years, 3 months
seen Nov 4 at 0:03

SCHWUPPS-DI-WUPPS


Nov
4
awarded  Popular Question
Nov
3
awarded  Popular Question
Sep
25
awarded  Popular Question
Sep
24
revised Optimal config for a small vserver with ispconfig
added 125 characters in body
Sep
24
awarded  Curious
Sep
23
asked Optimal config for a small vserver with ispconfig
Jul
23
comment What are the disadvantages if indexes are added on all columns?
So from what I read here, my advice to my friend, that put indexes on all his database columns in all tables, would be that this is still the better solution than don't having indexes at all. Is this correct? (sure, I know the best solution would be he puts only the needed indexes, but he doesn't want to learn that)
Jul
23
awarded  Popular Question
Jun
17
comment PHP SQLite Admin is running on PHP 5.4
cool, with phpliteadmin I could manage my owncloud SQLite database /var/www/owncloud/data/owncloud.db. (I copied the database into the phpliteadmin folder for a start)
Jun
17
accepted PHP SQLite Admin is running on PHP 5.4
Jun
17
asked PHP SQLite Admin is running on PHP 5.4
Jun
12
awarded  Citizen Patrol
Feb
8
awarded  Revival
Jan
9
comment Select the latest changed row in a table
So in which mysql versions is this introduced? In 5.1 it seems to work perfect with the ORDER BY
Nov
12
awarded  Famous Question
Sep
25
awarded  Yearling
Sep
18
comment Select the latest changed row in a table
I would say in this solution, the chosen value is determinate: because the temorary table is sorted by changedate DESC, there will be chosen the first row of that result. But for other cases without a sorting you are right
Sep
17
comment Select the latest changed row in a table
@ypercube: so can you post a better alternative answer?
Sep
17
revised Select the latest changed row in a table
changed the output name for clarity
Sep
17
comment Select the latest changed row in a table
cool that works. so TEST should be AS output_descriptor