MySQL: Column aliases are not displayed as column headers in result sets Print

I can't see bar as column header in the result set for the following query. I always get foo.

select foo as 'bar' from mytable

Solution:

In the MySQL JDBC driver 5.1 decided to change how their JDBC driver handle aliases. The workaround is to set the following driver property in the Connection properties under Driver Properties:

useOldAliasMetadataBehavior = true