Is this situation possible during executing mySQL query in PHP?

J

Jerald L

New member
Suppose that there are 1 billion records on a table,

then i execute mysql query in php, something like


"UPDATE `table` SET `Field`= 'value' WHERE `Gender`='Male'"

but during the execution, the system crashed (server or client)

is there a possibility that the
half of the records are updated and half aren't, or some problem like this.
 
That can certainly happen, because it will do them, though fast, sysematically, and therefore if it crashed in the middle of the process only the already processed ones would have been executed
 
Back
Top