[sqlite] The fastest way to change the data of a table?

Hi, Basically, I need to do the following: given a big-big table, I need to iterate through all its rows and change a column in about half the rows. The contents of the column to change depends on other columns, but only partially, so triggers won't work here. What would be the fastest way to

Re: [sqlite] The fastest way to change the data of a table?

Alexei Alexandrov a écrit : Hi, Basically, I need to do the following: given a big-big table, I need to iterate through all its rows and change a column in about half the rows. The contents of the column to change depends on other columns, but only partially, so triggers won't work here.