updating multiple rows and another question

[kaygee79]

Is there a way to updateByPk more than one row at once obviously using different primary keys? I have a bunch of rows to update and don’t want to keep repeating updateByPk over and over. Can I combine the query somehow?

Also is there a way of doing something like "UPDATE some_row SET some_row = some_row + 1 WHERE … ?

Thanks in advance!!!

[phtamas]

Is there a way to updateByPk more than one row at once obviously using different primary keys? I have a bunch of rows to update and don’t want to keep repeating updateByPk over and over. Can I combine the query somehow?

updateByPk() accepts an array of primary key values as its first parameter.

Also is there a way of doing something like "UPDATE some_row SET some_row = some_row + 1 WHERE … ?

updateCounters()

[kaygee79]

updateByPk() accepts an array of primary key values as its first parameter.

so it will be the same sql query applied to all the pk? can you have different query executed for each pk?

updateCounters()

Perfect! Thank you.