Reputation
881
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
6 26 42
Impact
~196k people reached

  • 0 posts edited
  • 0 helpful flags
  • 116 votes cast
Jan
9
asked Is column order reliable in UPDATE?
Jan
9
accepted How to categorize rows by SUM of a column in mysql?
Jan
8
awarded  Critic
Jan
8
comment How to do two actions in conditional UPDATE?
@SebastianMeine sorry I forgot to include the PRIMARY_KEY, which is AUTO_INCREMENT.
Jan
8
comment How to do two actions in conditional UPDATE?
@ypercube I added an example.
Jan
8
revised How to do two actions in conditional UPDATE?
added 341 characters in body; edited tags
Jan
8
asked How to do two actions in conditional UPDATE?
Jan
8
revised How to use LOW_PRIORITY for heavy queries?
added 36 characters in body; edited tags
Jan
8
asked How to use LOW_PRIORITY for heavy queries?
Jan
8
accepted UPDATE a column by COUNT of another table
Jan
8
asked UPDATE a column by COUNT of another table
Jan
7
accepted How to mix pairs of rows without JOIN (in a temporary table)?
Jan
7
accepted How to re-arrange rows to best fit within groups?
Jan
7
accepted How to UPDATE a table for the level of parents in a column?
Jan
7
accepted How to get missing values in row order?
Jan
7
accepted Do regular ALTERs weaken the performance?
Jan
7
accepted How to update a table by count from another table?
Jan
6
accepted Grant access on a database to all users
Jan
6
asked Grant access on a database to all users
Dec
21
accepted Using OFFSET in a large table by a simple sub-query