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

intentionally left blank


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
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.