Row movement for MySQL partitionned tables

[jongse park]

I am currently considering partitionning tables on my company's application and i was unable to find anywhere in the documentation anything about row movement.

How does MySQL partitionned tables handle updates on records that would move the record from one partition to another?

Exemple : table1 is a InnoDB table partitionned on the value of col1 which is an integer value.

The value of col1 for each record of table one will increase from 0 to 6 at different point of the time through UPDATE queries.
What happends when a record is updated to have its col1 value change from 0 to 1 ? Does it trigger an error? Does MySQL delete the record from p0 and inserts a new one into p1?

Thanks!