All

548 reputation

1517

bio	website	phpfreaks.com
	location	United States (but travelling)
	age	34
visits	member for	1 year, 8 months
	seen	Jun 13 at 10:19
stats	profile views	36

I am not a handy programmer but I play with php with a hope to develop creative ideas.

	548 reputation	bio	website	phpfreaks.com	visits	member for	1 year, 8 months
1517 badges		location	United States (but travelling)		seen	Jun 13 at 10:19

summary answers questions tags badges favorites bounties reputation activity

175 Actions

suggestions reviews revisions comments badges posts accepts all

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 `SELECT`ing 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.
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