MySQL create temporary table with auto_increment id and select query

Question

want to create a temporary table that has an auto_increment field plus a field that has to be select from another table.

Here is what I have (does not work)

CREATE TEMPORARY TABLE tmp  (id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
(SELECT valueName AS valueName
FROM sometable
WHERE sometable.somevalue='00'));

these work by them selves but can get the right syntax to do both

CREATE TEMPORARY TABLE tmp  (id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY)

CREATE TEMPORARY TABLE tmp AS SELECT valueName AS valueName FROM sometable
WHERE sometable.somevalue='00';

Answer 1

I think you might be trying to do the first case outlined here:

http://dev.mysql.com/doc/refman/5.5/en/create-table-select.html

..which for your example would look like:

CREATE TEMPORARY TABLE tmp (id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY) 
SELECT valueName AS valueName FROM sometable
WHERE sometable.somevalue='00';

..so it might just be the parens in the wrong places that bit you in your first try.