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


Dec
20
asked How to re-assign two variables in a conditional UPDATE
Dec
20
accepted How to UPDATE a column to SET previous row value to NULL cells?
Dec
19
revised How to re-arrange rows to best fit within groups?
added 249 characters in body
Dec
19
asked How to re-arrange rows to best fit within groups?
Dec
17
revised How to categorize rows by SUM of a column in mysql?
edited body
Dec
17
comment How to categorize rows by SUM of a column in mysql?
@dezso why subquery is not slow? subquery needs to conduct the process row by row. Am I wrong?
Dec
17
comment How to categorize rows by SUM of a column in mysql?
Thanks for two versions, but please note that the question originally asked for UPDATE the table, rather than SELECTing the data.
Dec
17
comment How to categorize rows by SUM of a column in mysql?
yes I was thinking of user-variable, but I wished not to use sub-query, as it is slow in long tables (which is my case). But it seems, I have no other choice!
Dec
17
revised How to categorize rows by SUM of a column in mysql?
added 158 characters in body
Dec
17
asked How to categorize rows by SUM of a column in mysql?
Dec
16
accepted How to GROUP_CONCAT between given rows?
Dec
16
accepted How to split a string to and get info from another table in mysql
Dec
16
accepted Which RDBMS has the most advanced “table-valued” functions?
Dec
16
accepted How to order query results by tag weight in IN('tag1', 'tag2', 'tag3')
Dec
16
accepted Is it bad to create many mysql temporary tables simultaneously?
Dec
16
asked How to UPDATE a column to SET previous row value to NULL cells?
Dec
14
accepted Splitting a column to normalized table
Dec
14
asked How to GROUP_CONCAT between given rows?
Dec
13
asked Splitting a column to normalized table
Dec
12
comment Which RDBMS has the most advanced “table-valued” functions?
@JustinCave The reason for denormalization is that the individual words, if see in the original question, have no meaning or dependency in the database. We just want to calculate the sum of scores for a sentence (not even word). Thus, splitting the cell to numerous rows is not beneficial. De-normation in this case, is to create another table with one-to-many relationships to calculate the sentence score. This is indeed my goal; but that table should be virtual, because after update it is no longer needed.