803 reputation
11839
bio website phpfreaks.com
location United States (but travelling)
age 35
visits member for 3 years, 2 months
seen Aug 24 at 14:04

intentionally left blank


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?
Sep
15
accepted JOIN to read first table and get possible relationship in the second table
Sep
15
accepted Is it possible to force drop of mysql tables with FK?
Sep
15
accepted HOW to “SUM” and “JOIN” for single query of a poll results?
Sep
15
accepted How to run a SELECT query within while loop in PHP?
Sep
15
accepted Does a TRIGGER improve the performance?
Sep
15
accepted How to use OR in query with priority?