Does MySQL prevent updates from occurring when the values involved are the
same as the database's current state.
For instance, if I've got a table
create table updater(
id int not null primary key auto_increment,
is_active int not null default 1
};
insert into updater(is_active) values (1);
in
I've got the following 2 tables:
create table cinema_order (
id int not null primary key auto_increment,
revision_number int not null default 1,
active_revision int not null default 1
);
create table cinema_order_revision (
id int not null primary key auto_increment,
cinema_order_id int not null
