MySQL:Copy data to table from it

[ramez_sever]

hello .....

how are you all;

i want to ask you a question

i have a data in a table answer and i want to copy the data which have a specific value in a filed and inserted into it again but i will change the value

i try to use this but it's give me an error

INSERT INTO answer ( answer , correct,qid )
SELECT a2.answer , a2.correct , 3

FROM answer as a2 where a2.qid=0

[Danicek]

Your syntax seems right.

Insert Into table_name(column_list) Select...

is right. What error message you get?

[ramez_sever]

cannt use the same table in insert and select

=============Erro===============

INSERT TABLE 'answer' isn't allowed in FROM table list

===============================

[Danicek]

Ah, I did not noticed this.
Yes, ofcourse that is one of restrictions.
Then you need to use kind of "intermediary" table. Insert your values there and then copy them back.