I need to update the value in the table base on id match in WHERE IN claus

Asked Apr 16 '20 at 13:15

Active Apr 16 '20 at 13:27

Viewed 17 times

I have array of data like below:

$data = Array
(
    [0] => Array
        (
            [id] => 29
            [value_1] => 1
            [value_2] => 1
            [value_3] => 1
        )

    [1] => Array
        (
            [id] => 116
            [value_1] => 1
            [value_2] => 1
            [value_3] => 1
        )

)

and i have to update it like in update query where in the id matched then set the only particular values for that. suppose my query like this

update table set value1 = $data[matched_id_index]['value_1'],value2 = $data[matched_id_index]['value_2'],value3 = $data[matched_id_index]['value_3'] where id in (data[0]['id'],$data[1]['id]);

Means basically i need to update the matched id value for particular column.

edited Apr 16 '20 at 13:27

asked Apr 16 '20 at 13:15

Mahesh Sanjay Tirmali

you cannot update using WHERE IN. run separate queries for each array – Your Common Sense Apr 16 '20 at 13:18
done with this but takes long time to update through multiple queries – Mahesh Sanjay Tirmali Apr 16 '20 at 13:20
so you had to ask exactly that question – Your Common Sense Apr 16 '20 at 13:22
It working fine with inserting data but while updating take too much long time and we have to update thousands of records and we are also using the primary for better performs but things seems hopeless – Mahesh Sanjay Tirmali Apr 16 '20 at 13:24
updating thousands of records takes a fraction of second – Your Common Sense Apr 16 '20 at 13:27

I need to update the value in the table base on id match in WHERE IN claus

0 Answers0