316 reputation
1211
bio website coffeeplusplus.z11.de
location Germany
age 42
visits member for 1 year, 6 months
seen Jan 9 at 9:37

SCHWUPPS-DI-WUPPS


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
Aug
2
asked How identify tables with millions of entries
May
21
awarded  Caucus
Apr
23
asked Is there slowdown inserting into an InnoDB table that has no index set?
Apr
15
comment What are the disadvantages if indexes are added on all columns?
For example: if the table has just 5 varchar(255) columns and 4 million entries, would it slow down the planner significantly then, if there were indexes on all columns, compared to only indexes on the columns that are used in the query?
Apr
15
revised What are the disadvantages if indexes are added on all columns?
added 8 characters in body; edited title
Apr
15
comment What are the disadvantages if indexes are added on all columns?
so why the downvote? if it was, cause i said "field" before, you can reverse the downvote now. and you can delete your comments about it