150个字段更新 - PHP + MYsql最佳解决方案

Question

I am reading one XML field which has 150 tags ( fields ) in it.My XML field has the foll fields

productid, name and soon... 150 fields

The feeds shows me the data which is EITHER a NEW record or the DATA which is updated.

I know how to read, insert, update data in PHP/Mysql.

My main concern is that when there is an UPDATE, do i have to write UPDATE statement for all 150 fields ? Is there any shortcut to UPDATE only the fields that has been changed ?

Is it the STANDARD METHOD to write UPDATE name SET name = name, WHERE ... for ALL 150 fields ?

Or is there any SMART solution for doing this, because i dont think its best solution to update all fields ( if anyone of the field is updated )

Answer 1

You can update all 150 fields with just one query.

UPDATE tbl SET field1 = val1, field2 = val2, ..., fieldn = valn WHERE condition

It sounds like you're concerned about whether it's feasible to update all 150 fields in one query, and I don't see an issue with that. Alternatively, you would have to first select the tuple from the database, then compare each of the 150 fields, and update the database. That seems like a lot more work than just updating everything. That's two queries and a lot of comparisons instead of just one query.