Is it possible to get the field type from a MySQL query, in the same way you can get it from a table with the
SHOW COLUMNS command?
edit: i should clarify that a bit. I am aware that I can get the field types PER TABLE with the methods suggested below. However I would need the field types from query results that combine fields from multiple tables via Joins and Unions.
I was hoping there was something similar to the
EXPLAIN command that could do the work for me. I really don't want to parse the SQL query myself, find involved tables and fields and then look up information_schema for the fields I found there...