To force the command line client 'mysql' to show warnings use the –show-warnings option. This especially useful when running a sql script from the CLI using the '.' or 'source' commands.
[found this info on the mysql online Reference manual page, in a posting by Marcus Bointon ]
This was not available in older versions and I didnt bother to check for any other alternatives since luckily I dont have a requirement to stick to any of the older versions.