![]() |
Support JOIN in UPDATE - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28) +--- Forum: CodeIgniter 4 Feature Requests (https://forum.codeigniter.com/forumdisplay.php?fid=29) +--- Thread: Support JOIN in UPDATE (/showthread.php?tid=90804) |
Support JOIN in UPDATE - objecttothis - 05-07-2024 PHP 8.2 MySQL 8.2 Apache 2.4 CI 4.5.1 With the code PHP Code: $builder = $this->db->table('attribute_links'); I expect the generated SQL to be Code: UPDATE `ospos_attribute_links` What I get is Code: UPDATE `ospos_attribute_links` This is completely missing the join. Your batch update (https://codeigniter.com/user_guide/database/query_builder.html#update-from-data) examples shows joins being generated in an update, so I know it's possible, but doesn't seem to be implemented. |