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
Jan
11
awarded  Notable Question
Jan
9
comment Is column order reliable in UPDATE?
I totally understand the unreliability you quoted, but for a simple arithmetic mentioned in the question, a guaranteed order of UPDATE can satisfy the user variable re-SET. Ain't it?
Jan
9
comment Is column order reliable in UPDATE?
@GarethD my case is single table, is there a guarantee that UPDATE is from left to right? as we can use ORDER BY for single table, but not multiple-tables?
Jan
9
revised Is column order reliable in UPDATE?
deleted 27 characters in body
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?