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

intentionally left blank


Jan
8
awarded  Critic
Jan
8
comment How to do two actions in conditional UPDATE?
@SebastianMeine sorry I forgot to include the PRIMARY_KEY, which is AUTO_INCREMENT.
Jan
8
comment How to do two actions in conditional UPDATE?
@ypercube I added an example.
Jan
8
revised How to do two actions in conditional UPDATE?
added 341 characters in body; edited tags
Jan
8
asked How to do two actions in conditional UPDATE?
Jan
8
revised How to use LOW_PRIORITY for heavy queries?
added 36 characters in body; edited tags
Jan
8
asked How to use LOW_PRIORITY for heavy queries?
Jan
8
accepted UPDATE a column by COUNT of another table
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?