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
=======================