Is it possible to retrieve the column count of a temporary table. Basically I want to get it like this where I can check column names and data types. But I keep getting an error. Saying table doesn't exist, I believe because it is looking for the actual table not the temp one.
Code:
SELECT COUNT(*)
FROM `INFORMATION_SCHEMA`.`Columns`
WHERE `TABLE_NAME`='Split' && ((`COLUMN_NAME`='id' && `DATA_TYPE`='INT') || (`COLUMN_NAME`='value' && `DATA_TYPE`='TEXT') || (`COLUMN_NAME`='key' && `DATA_TYPE`='INT')) && `TABLE_SCHEMA`=@database
Before you post, read our: 
