Reports

try to use this DML command with a prepared statement

    set @variable = 'column_name';

    set @cmdSql = "UPDATE famcharts_old.db1w_matrix 
    JOIN famcharts_old.tbl_dirtosv ON famcharts_old.tbl_dirtosv.PlaceOT = 
    famcharts_old.db1w_matrix.SERVICE_ID
    and famcharts_old.tbl_dirtosv.Dir_ID IN (a LIST-of-values)
    JOIN famcharts_old.tbl__dir__base
    ON all_directives.DirID = famcharts_old.tbl_dirtosv.Dir_ID
    SET famcharts_old.db1w_matrix.";
    
    set @cmdSql=Concat(@cmdSql,@variable);
    
    set @cmdSql=Concat(@cmdSql," = famcharts_old.tbl_dirtosv.NiceNeed; ");
    
    
     Prepare execSQL from @cmdSql;

     Execute execSQL; 

     DEALLOCATE PREPARE execSQL;

More instructions check: https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html

79114424