How to Update a Column in a Table from Another Table’s Column

Some time you want to update a column in a table from another table’s column and in magento 2 you can use “updateFromSelect” function to do it.

• This is an example in resouce model

$connection = $this->getConnection(); $select = $connection->select()   ->from(       ['main_table' => $this->getResource()->getMainTable()]   )   ->joinLeft(['join_table'=>$this->getTable('join_table')],       "main_table.id = join_table.id",       array('name' => 'name')); $query = $connection->updateFromSelect(   $select,   ['main_table' => $this->getResource()->getMainTable()] ); $connection->query($query); 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 $connection = $this->getConnection();   $select = $connection->select()     ->from(         ['main_table' => $this->getResource()->getMainTable()]     )     ->joinLeft(['join_table'=>$this->getTable('join_table')],         "main_table.id = join_table.id",         array('name' => 'name'));   $query = $connection->updateFromSelect(     $select,     ['main_table' => $this->getResource()->getMainTable()]   );     $connection->query($query);

• And this is the query after the code is render

Hope it helpful for you.

The steps I mention above is the shortest process for you to Update a Column in a Table from Another Table’s Column in Magento 2.

Thank you for reading this post and see you in other posts from Magestore!

Your Magento website needs a powerful Magento ERP for stock control.

DON'T MISS THE CHANCE!