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


2d
awarded  Notable Question
Mar
1
awarded  Popular Question
Feb
19
awarded  Popular Question
Feb
17
awarded  Popular Question
Feb
4
awarded  Popular Question
Jan
28
awarded  Popular Question
Jan
24
awarded  Popular Question
Jan
16
comment Alternative to TEMPORARY tables capable of re-opening in a query?
@a_horse_with_no_name that's a practical idea, but does postgres support this feature for TEMPORARY tables? If yes, I would do this, as there is no solution with mysql.
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?