Reputation
866
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
5 25 41
Impact
~184k people reached

  • 0 posts edited
  • 0 helpful flags
  • 116 votes cast
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
Dec
21
asked Using OFFSET in a large table by a simple sub-query
Dec
15
accepted How to UPDATE a column by COUNT of FK from another table?
Dec
15
comment How to UPDATE a column by COUNT of FK from another table?
does it have any advantage? I use COUNT(*) as I've read it is faster in innoDB comparing with other possibilities including COUNT(primary_key).