The task is to copy the value of the oldfield field to newfield field
[code]
UPDATE table2 SET newfield = (SELECT oldfield FROM main_table WHERE table2.qid = main.qid)
[/code]
/ Stuffs About Website Development /
The task is to copy the value of the oldfield field to newfield field
[code]
UPDATE table2 SET newfield = (SELECT oldfield FROM main_table WHERE table2.qid = main.qid)
[/code]