I run this query

CREATE TEMPORARY TABLE usercount SELECT * FROM users

I get this message

Your SQL query has been executed successfully ( Query took 0.1471 sec )

But when I try to access the newly created table using

SELECT * FROM usercount

I get this error

#1146 - Table 'abc_site.usercount' doesn't exist

Not sure why, I need to mention that I've did a good share of googling beforehand.

My version of PHPMyAdmin is 3.5.2.2 and MySQL 5.5.27

mysql temp-tables
Edit
Report