79750854

Date: 2025-08-30 00:00:55
Score: 0.5
Natty:
Report link

In MySQL 8, you must put the subquery in a derived table:

UPDATE details_audit a
JOIN ( SELECT COUNT(*) AS cnt FROM details_audit WHERE sort_id < 100 ) b
SET a.count_change_below_100 = b.cnt
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Amir Roox