753 reputation
11636
bio website phpfreaks.com
location United States (but travelling)
age 35
visits member for 2 years, 10 months
seen Jun 7 at 0:20

intentionally left blank


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.
Dec
12
comment Which RDBMS has the most advanced “table-valued” functions?
@JustinCave I agree with your standpoint, but sometimes it is needed to de-normalize a database.
Dec
12
comment Which RDBMS has the most advanced “table-valued” functions?
Perl/Python/PHP all can handle string functions well, but the problem is that fetching data and updating the database for thousands of queries is not efficient in practice. I've heard that PostgreSQL is fairly advanced, but I did not find more string functions comparing with mysql (of course, by a quick review).
Dec
12
comment Which RDBMS has the most advanced “table-valued” functions?
This is a subtle solution for my case, but unfortunately I'm on linux.
Dec
12
comment Which RDBMS has the most advanced “table-valued” functions?
@RemusRusanu I do not look for an advanced RDMBS, as I think mysql is. I think string functions of mysql are not very extensive. I am looking for a RDBMS (advanced or basic) but with a wide range of functions for strings (table valued).
Dec
12
comment Which RDBMS has the most advanced “table-valued” functions?
@MartinSmith I edited the title as you instructed.
Dec
12
revised Which RDBMS has the most advanced “table-valued” functions?
edited title
Dec
12
asked Which RDBMS has the most advanced “table-valued” functions?
Dec
12
asked How to split a string to and get info from another table in mysql
Dec
4
accepted How to concatenate a column after x rows?
Dec
4
comment How to concatenate a column after x rows?
@RolandoMySQLDBA what should I like it when it magically and perfectly works? I love it :)
Dec
4
comment How to concatenate a column after x rows?
@FrustratedWithFormsDesigner this is a simple loop ordered by the primary key (auto_increment).
Dec
4
revised How to concatenate a column after x rows?
added 226 characters in body
Dec
4
comment How to concatenate a column after x rows?
@RolandoMySQLDBA yes, exactly! I want to reset the sum, and calculate the sum to reach the next 20. In fact, this is a loop of INSERTs for groups reaching the sum of frequency of 20 after the last INSERT.
Dec
4
comment How to concatenate a column after x rows?
This is brilliant, but this will work for one INSERT when the sum of frequency reaches the value. But I want to repeatedly INSERT and reset the sum of frequency