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
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
Sep
19
asked How to UPDATE a table for the level of parents in a column?
Sep
17
awarded  Nice Question
Sep
17
comment Do regular ALTERs weaken the performance?
@MaxVernon the project is in beta mode, not alpha. Changes to the database is not about core columns, but additional columns, usually making FK to other tables. The project is conducted based on end-user feedback.
Sep
17
asked How to get missing values in row order?
Sep
16
comment Do regular ALTERs weaken the performance?
@MaxVernon I know that it sounds crazy, but it is a live project in which the database structure is about to modified. Unfortunately, due to the rush, we could now extend the test period.
Sep
16
asked Do regular ALTERs weaken the performance?