Reputation
871
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
6 26 42
Impact
~188k people reached

  • 0 posts edited
  • 0 helpful flags
  • 116 votes cast
Feb
18
awarded  Popular Question
Jan
9
comment How to re-arrange rows to best fit within groups?
This method will change the order in cat, which is the main requirement. It is needed to preserve the order in each category. The flexibility is where categories are mixed.
Jan
8
awarded  Promoter
Dec
22
revised How to re-arrange rows to best fit within groups?
added 107 characters in body
Dec
22
accepted Multiple “GROUP_CONCAT”s with WHERE clause
Dec
22
comment Multiple “GROUP_CONCAT”s with WHERE clause
I think the first solution is simple and elegant and well fit with my need.
Dec
22
asked Multiple “GROUP_CONCAT”s with WHERE clause
Dec
21
revised How to mix pairs of rows without JOIN (in a temporary table)?
added 2 characters in body; edited title
Dec
21
comment How to mix pairs of rows without JOIN (in a temporary table)?
@JeremySmyth mysql does not support JOIN to self on temporary tables. Temporary tables can be referenced only once in a query.
Dec
21
asked How to mix pairs of rows without JOIN (in a temporary table)?
Dec
20
accepted How to re-assign two variables in a conditional UPDATE
Dec
20
comment How to re-assign two variables in a conditional UPDATE
very subtle solution, and I enjoyed your useful presentation!
Dec
20
revised How to re-assign two variables in a conditional UPDATE
edited title
Dec
20
asked How to re-assign two variables in a conditional UPDATE
Dec
20
accepted How to UPDATE a column to SET previous row value to NULL cells?
Dec
19
revised How to re-arrange rows to best fit within groups?
added 249 characters in body
Dec
19
asked How to re-arrange rows to best fit within groups?
Dec
17
revised How to categorize rows by SUM of a column in mysql?
edited body
Dec
17
comment How to categorize rows by SUM of a column in mysql?
@dezso why subquery is not slow? subquery needs to conduct the process row by row. Am I wrong?
Dec
17
comment How to categorize rows by SUM of a column in mysql?
Thanks for two versions, but please note that the question originally asked for UPDATE the table, rather than SELECTing the data.