738 reputation
11030
bio website phpfreaks.com
location United States (but travelling)
age 34
visits member for 2 years, 6 months
seen Apr 7 at 9:35

intentionally left blank


Jan
14
revised How to UPDATE MAX and MIN of a GROUP BY?
added 1 characters in body
Jan
14
revised How to UPDATE MAX and MIN of a GROUP BY?
deleted 27 characters in body
Jan
9
revised Is column order reliable in UPDATE?
deleted 27 characters in body
Jan
8
revised How to do two actions in conditional UPDATE?
added 341 characters in body; edited tags
Jan
8
revised How to use LOW_PRIORITY for heavy queries?
added 36 characters in body; edited tags
Dec
15
revised How to UPDATE a column by COUNT of FK from another table?
edited title
Aug
28
revised Does a TRIGGER improve the performance?
added 66 characters in body
Aug
26
revised Enabling LOAD DATA LOCAL INFILE in mysql
deleted 167 characters in body; edited title
May
26
revised Is it possible to force drop of mysql tables with FK?
deleted 8 characters in body; edited title
May
22
revised JOIN to read first table and get possible relationship in the second table
added 203 characters in body
Dec
22
revised How to re-arrange rows to best fit within groups?
added 107 characters in body
Dec
21
revised How to mix pairs of rows without JOIN (in a temporary table)?
added 2 characters in body; edited title
Dec
20
revised How to re-assign two variables in a conditional UPDATE
edited title
Dec
19
revised How to re-arrange rows to best fit within groups?
added 249 characters in body
Dec
17
revised How to categorize rows by SUM of a column in mysql?
edited body
Dec
17
revised How to categorize rows by SUM of a column in mysql?
added 158 characters in body
Dec
12
revised Which RDBMS has the most advanced “table-valued” functions?
edited title
Dec
4
revised How to concatenate a column after x rows?
added 226 characters in body
Dec
4
revised How to concatenate a column after x rows?
added 255 characters in body
Nov
22
revised Is it always bad to use SELECT * FROM?
added 1 characters in body