将四行显示为一行(Mysql)

Question

​

​

我有四列和四行数据库如何显示为一行一列。

示例：

  > UID    TIME MIN     MON     MOUT        AIN       AINOUT
        > 14406  2022-08-7   ontime     -          -          -
          14406   2022-8-7      -      ontime      -          -
          14406   2022-08-07     -      -         ontime      -
          14406  2022-08-07     -       -         -          ontime

如何用一个uid制作一些薄的lik这个

    > UID    TIME MIN     MON     MOUT        AIN       AINOUT
    > 14406  2022-08-7   ontime  on time    ontime   on time

Answer 1

就你的具体情况而言：

  SELECT d1.uid, DATE(d1.time) time, d1.min, d2.mout, d3.ain, d4.aout
    FROM devices d1, devices d2, devices d3, devices d4
   WHERE d1.min <> '' AND d2.mout <> '' AND d3.ain <> '' AND d4.aout <> '';

干杯

Answer 2

您必须使用以下查询排列您的列：

 SELECT uid,time,time_search,min(min) as min,min(mout) as mout,min(ain) as ain,min(aout) as aout FROM db_tbl_name GROUP BY uid,time,time_search

这对于在一行中获取多个保留数据是很好的。