1,471 reputation
615
bio website
location Ukraine
age
visits member for 2 years, 1 month
seen yesterday

Jul
14
revised COUNT of rows with parent id equal to the row we have with a parent id of 0 in one query
tag in the title, redundant capitalisation
Jul
14
suggested suggested edit on COUNT of rows with parent id equal to the row we have with a parent id of 0 in one query
Jul
14
revised School database design
improved formatting, edited title to reflect the question more acurately
Jul
14
suggested suggested edit on School database design
Jul
14
comment COUNT of rows with parent id equal to the row we have with a parent id of 0 in one query
You want to group by parent_id and count rows in every group, selecting only results where parent_id <> 0.
Jul
13
revised How do I minimise logging during a large insert?
typo in the title
Jul
13
suggested suggested edit on How do I minimise logging during a large insert?
Jul
12
comment Most efficient ordering post database design
Can we assume that the post_order column is maintained to be always sequential (particularly after such operations as inserts and deletes)?
Jul
12
answered How to merge two rows in a table?
Jul
12
revised Need to find the number of employee who are not in all department
"e.g." alone translates as "for example", another "for" is redundant; formatting improved
Jul
12
suggested suggested edit on Need to find the number of employee who are not in all department
Jul
11
comment Need to find the number of employee who are not in all department
It would be really great if you incorporated the explanation of why the GROUP BY was important into your answer.
Jul
11
revised Tips on improving/refactoring slow query?
improved formatting
Jul
11
comment Tips on improving/refactoring slow query?
What indices have you got? How slow is your very slow and how fast do you want it to be?
Jul
11
suggested suggested edit on Tips on improving/refactoring slow query?
Jul
10
comment Unable to generate a MySQL query
Are the Timestamp values unique? Or are they unique at least per ID?
Jul
9
revised Temporarily Disable Sql Replication
formatting
Jul
9
suggested suggested edit on Temporarily Disable Sql Replication
Jul
9
revised mysql binlog file size stop growing
grammar, formatting
Jul
9
reviewed Reviewed mysql binlog file size stop growing