Mysql Copy a field’s value to another related table
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]