damn mysql subqueries

[sid]

can anybody point me to where im going wrong here?

INSERT INTO bands_media
(bandid, mediatype, filename)
VALUES ((SELECT bandid, 1, pic FROM bands));

error:

SQL-query :  

INSERT INTO bands_media( bandid, mediatype, filename ) 
VALUES (

(

SELECT bandid, 1, pic
FROM bands
)
) 

MySQL said: 


#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT bandid, 1, pic
FROM bands ) )' at line 5

thanks much!

[LordShryku]

You don't use the VALUES keyword in that kind of subquery. Try this:

INSERT INTO bands_media 
  (bandid, mediatype, filename)
  SELECT bandid, 1, pic FROM bands;

[sid]

is it a plane? NO
is it a bird? NO
its the lord saving the day once again ;-)

[LordShryku]

Now all I need is a theme song 😃

[sid]

im all for the knight rider tune

[LordShryku]

Yeah. but then I'd need my Kit car too