string updateQuery = @"UPDATE `characters`.* SET AccountId = @AccountId WHERE WEAPON_PRIMARY = @WEAPON_PRIMARY"; var update = SqlMapper.Execute(connection, updateQuery, new { WEAPON_PRIMARY = weapon_primary }); Code: C#