Reputation
931
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
8 29 45
Impact
~219k people reached

  • 0 posts edited
  • 0 helpful flags
  • 116 votes cast
Jan
14
revised How to UPDATE MAX and MIN of a GROUP BY?
deleted 27 characters in body
Jan
14
asked How to UPDATE MAX and MIN of a GROUP BY?
Jan
14
accepted Use string functions and arithmetic calculations in SQL query or by programming language?
Jan
14
asked Use string functions and arithmetic calculations in SQL query or by programming language?
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)?