I believe a combination of DBI and DBD::mysql can give you what you are looking for. The $sth->do method returns the number of items affected. The DBD::mysql has a 'mysql_warning_count' parameter that is non-portable, if you want to get the warnings.

I suspect, however, that you are looking for the exact string you see from the CLI '0 rows affected, 7 arnings...). This is a common desire, but it is not coming from the engine -- this comes from the CLI (ie, running the 'mysql' command from the *nix prompt). I believe you can generate all this info yourself, just not with a single call