Re: Adding values returned by GREATEST

2016-05-23 Thread Hal.sz S.ndor
2016/05/14 16:23 ... shawn l.green: > ... If the numeric > value is quoted, it is still interpreted as an index if there is no > matching string in the list of enumeration values. One of the many cases where I believe that MySQL s attempt to be helpful by converting is not helpful. Thus it wa

Re: Adding values returned by GREATEST

2016-05-14 Thread shawn l.green
On 5/14/2016 2:57 PM, Peter Brawley wrote: On 5/14/2016 11:16, shawn l.green wrote: Hello Sukhjinder, On 5/3/2016 8:55 AM, Sukhjinder K. Narula wrote: Hello, i have a question regarding the GREATEST function of mysql. I would like to add the values returned by GREATEST function is mysql, s

Re: Adding values returned by GREATEST

2016-05-14 Thread Peter Brawley
On 5/14/2016 11:16, shawn l.green wrote: Hello Sukhjinder, On 5/3/2016 8:55 AM, Sukhjinder K. Narula wrote: Hello, i have a question regarding the GREATEST function of mysql. I would like to add the values returned by GREATEST function is mysql, so a query is like below: For example table t

Re: Adding values returned by GREATEST

2016-05-14 Thread shawn l.green
Hello Sukhjinder, On 5/3/2016 8:55 AM, Sukhjinder K. Narula wrote: Hello, i have a question regarding the GREATEST function of mysql. I would like to add the values returned by GREATEST function is mysql, so a query is like below: For example table t has 6 fields with values as follows: A = 1

Adding values returned by GREATEST

2016-05-03 Thread Sukhjinder K. Narula
Hello, i have a question regarding the GREATEST function of mysql. I would like to add the values returned by GREATEST function is mysql, so a query is like below: For example table t has 6 fields with values as follows: A = 1, B = 3, C=0, D = 0, E = 1 and F = 0 and I run a query: SELECT GREATE