行的最小值和最大值，而不是列

In my mysql table on the same row i have a persons name, value1, value2, value3, value4, value5. I want to get the lowest value from values 1-5 and put it in column lowestvalue.

在我同一行的mysql表中,我有一个人名,value1,value2,value3,value4,value5。我想从值1-5获得最低值并将其放在列最低值。

I know how to get minimum and maximum values from a chosen column, as stated in mysql documentation 3.6.1, but i dont know how to get minimum and maximum values from a chosen row. I cant find that in mysql documentation.

我知道如何从所选列中获取最小值和最大值,如mysql文档3.6.1中所述,但我不知道如何从所选行中获取最小值和最大值。我在mysql文档中找不到。

Could some one tell me or point me in the right direction. Cheers

有人可以告诉我或指出我正确的方向。干杯

2 个解决方案

#1

SELECT GREATEST(`value1`, `value2`, `value3`, `value4`, `value5`) as `highest`
FROM `tablename` WHERE .....

#2

Create another table (name, value), link it with first table by name and use standart min/max functions

创建另一个表(名称,值),按名称将其与第一个表链接,并使用标准的最小/最大函数