Insert query Problem

[Limno]

insert into test (userid,questio n_id) ('1',select question_id from question ORDER BY RAND() LIMIT 2 )

i need to insert values from question table with userid as 1.

How can i solve ths problem

Thanks in Advance

[mwasif]

Use INSERT INTO TABLE.

[Atli]

The INSERT INTO statement can take the result set of a SELECT query as the set of data it is supposed to insert. You simply replace the VALUES clause with a SELECT query.

Try something more like:
[code=sql]INSERT INTO `tbl_1`(`id`, `value`)
SELECT 1, `value`
FROM `tbl_2`
ORDER BY RAND()
LIMIT 10;[/code]