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


Jan
15
asked Alternative to TEMPORARY tables capable of re-opening in a query?
Jan
15
asked How to categorize pairs of tags?
Jan
14
revised How to UPDATE MAX and MIN of a GROUP BY?
added 1 characters in body
Jan
14
comment How to UPDATE MAX and MIN of a GROUP BY?
@Mihai sorry that was a typo. The first and last rows in a category if col1='x'
Jan
14
comment How to UPDATE MAX and MIN of a GROUP BY?
@ShlomiNoach in mysql, it is not possible to open a table twice. Thus, it cannot JOINed to itself.
Jan
14
revised How to UPDATE MAX and MIN of a GROUP BY?
deleted 27 characters in body
Jan
14
asked How to UPDATE MAX and MIN of a GROUP BY?
Jan
14
accepted Use string functions and arithmetic calculations in SQL query or by programming language?
Jan
14
asked Use string functions and arithmetic calculations in SQL query or by programming language?
Jan
11
awarded  Notable Question
Jan
9
comment Is column order reliable in UPDATE?
I totally understand the unreliability you quoted, but for a simple arithmetic mentioned in the question, a guaranteed order of UPDATE can satisfy the user variable re-SET. Ain't it?
Jan
9
comment Is column order reliable in UPDATE?
@GarethD my case is single table, is there a guarantee that UPDATE is from left to right? as we can use ORDER BY for single table, but not multiple-tables?
Jan
9
revised Is column order reliable in UPDATE?
deleted 27 characters in body
Jan
9
asked Is column order reliable in UPDATE?
Jan
9
accepted How to categorize rows by SUM of a column in mysql?
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?