Is it possible to get exactly what the error is in MySQL?

I'm getting an error when trying to add a foreign key and the description i开发者_开发知识库s not helpful at all: it's error 1050 and all I'm able to find in Google are pages with a list of possible causes. Is there a way to get the exact cause of an error from mysql, for example "fields do not match (one is unsigned and another is signed) so you can't have a foreign key"?

If you run show engine innodb status\G at the MySQL prompt and look for the "LATEST FOREIGN KEY ERROR" section, that should give you more detail on the error.