MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning.
set sql = 'update CapitalAssetsActivity set Period= CHAR(?), Amount = ?'; set sql = sql || ' where SliceDimension1 = ? and AssetID = ? and Sequence = ?' ; set sql = sql || ' and Year = ? + CHAR(?)'; EXEC SQL EXECUTE sql USING : prevMonth, :tInBalance, :slice1, :assetId, :sequence, :prefix, :prevYear;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.