基本の構文

CONTENTS

1.【更新】UPDATE

2.【複数行】複数行をUPDATE
3.【データの準備】SET句を使う

UPDATE テーブル名
SET カラム1 = 値1, カラム2 = 値2, ...
WHERE 条件式;

UPDATE users
SET age = 30
WHERE id = 1;

UPDATE users

SET name = 'John', age = 25

WHERE id = 1;

UPDATE table1

JOIN table2

ON table1.id = table2.id

JOIN table3

ON table2.id = table3.id

SET

table1.column1 = 'new_value1',
table2.column2 = 'new_value2',
table3.column3 = 'new_value3'

WHERE table1.id = 'some_id';

UPDATE table1
JOIN table2 USING (id)
JOIN table3 USING (id)

SET

table1.column1 = 'new_value1',
table2.column2 = 'new_value2',
table3.column3 = 'new_value3'

WHERE

table1.id = 'some_id';

$query=$this->db->query("
UPDATE company_t
JOIN company_name_t
USING (company_id)

SET
company_t.company_id = $post_data_company,
company_name_t.company_name ='$post_data_company_name'

WHERE
company_name_t.company_id= $post_data_company
");

$this->db->where('company_id', $post_data_company);
$this->db->update('company_name_t', $input_data_company_name_t);