Reputation
951
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
8 30 46
Impact
~230k people reached

  • 0 posts edited
  • 0 helpful flags
  • 116 votes cast
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).
Dec
15
comment How to UPDATE a column by COUNT of FK from another table?
is it COUNT(*) ?
Dec
15
revised How to UPDATE a column by COUNT of FK from another table?
edited title
Dec
15
asked How to UPDATE a column by COUNT of FK from another table?
Nov
29
awarded  Popular Question
Oct
24
awarded  Notable Question
Oct
9
awarded  Yearling
Oct
1
awarded  Popular Question