Reputation
911
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
7 28 43
Impact
~209k people reached

  • 0 posts edited
  • 0 helpful flags
  • 116 votes cast
Apr
7
accepted How to JOIN two table to get missing rows in the second table
Apr
5
asked How to JOIN two table to get missing rows in the second table
Mar
27
awarded  Popular Question
Mar
16
awarded  Notable Question
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