If you want to change the value in qid to 3 when it is 0
You really need an update
update answer
setqid = 3
where qid = 0
-Original Message-
From: ÇÈæ ÇÈÑÇåíã [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 8:14 AM
To: [EMAIL PROTECTED]
Subject: copy from table to it
I think, there is an error in your syntax. (i am not sure)
After FROM, what do you want to call as a2 ??
INSERT INTO `answer` ( `answer` , `correct`,`qid` ) SELECT a2.`answer` , a2.`correct`
, 3 FROM `answer` where a2.qid=0
Vaso
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EM
