How to update mysql column with value from another table?
Md Ariful Islam
বিএসসি(সিএসই)
,
এমবিএ(মার্কেটিং)
1640 views
1 Answers
Md Ariful Islam
বিএসসি(সিএসই)
,
এমবিএ(মার্কেটিং)
UPDATE tableB t1
INNER JOIN tableA t2
ON t1.id = t2.id
SET t1.name = t2.name
.
UPDATE medicine_details t1
INNER JOIN tbl_drug_generic t2
ON t1.generic = t2.drug_generic
SET t1.generic_id = t2.drug_generic_id
1640 views
Answered