323 reputation
1213
bio website coffeeplusplus.z11.de
location Germany
age 42
visits member for 1 year, 11 months
seen Aug 11 at 10:10

SCHWUPPS-DI-WUPPS


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
Sep
17
suggested suggested edit on Select the latest changed row in a table
Sep
17
revised Select the latest changed row in a table
deleted 2 characters in body
Sep
17
asked Select the latest changed row in a table
Aug
4
comment How identify tables with millions of entries
I would add SET @MinTableRows = 10000; and AND table_rows>@MinTableRows to show only relevant tables
Aug
2
comment How identify tables with millions of entries
thanks! that works (only a typo: one "AND" too much). I will try to make cron-script out of that
Aug
2
comment How identify tables with millions of entries
Nearly all tables are MyISAM. I think it would suffice to check those