Unrecognized data type error in mysql stored procedure
<p>I am trying to run this query but I keep getting Unrecognized datatype near C.id.
What am I doing wrong?</p>

<pre><code>CREATE PROCEDURE `proc`
BEGIN
CREATE TABLE 
  temp_table  
AS (
  SELECT UNIQUE(C.id) FROM table1AS C
                INNER JOIN table2 AS CA ON CA.college_id in (8192)
                INNER JOIN table3 AS CS ON CS.skill_id in (2744)
)

select * from temp_table

END
</code></pre>

<p>Thanks.</p>