mysql - 如何使用group by sql更新集合

Question

我有absen表格的列如，

我这样查询，

SELECT count( tgl ) AS total, absen.id, absen.status, absen.kondisi,
CASE WHEN (weekday( tgl ) <=3) THEN date( tgl + INTERVAL( 3 - weekday( tgl ) ) DAY ) 
ELSE date( tgl + INTERVAL( 3 +7 - weekday( tgl ) ) DAY )
END AS tglitung
FROM absen
WHERE absen.status = 'm'
GROUP BY absen.id, tglitung

结果为

我要更新SET kondisi='yes' ，当 GROUP BY absen.id='15' AND tglitung='2016-01-14'

如何在这样的情况下使用设置更新？

Answer 1

试试这个:

UPDATE absen SET kondisi = 'yes'
WHERE id = 15 
    AND (CASE WHEN (WEEKDAY( tgl ) <=3) THEN DATE( tgl + INTERVAL( 3 - WEEKDAY( tgl ) ) DAY ) 
    ELSE DATE( tgl + INTERVAL( 3 +7 - WEEKDAY( tgl ) ) DAY )
    END) = '2016-01-14';