Insert / update in views using mysql

See more:

database

MySQL-Connector

My table Class_room

SLno--------class-------No_of_seats
001------------11-----------10
002------------10----------08
003------------09----------21

i had to create a view as done below

create view total_seats as select a.SLNo,a.class, count(a.NO_of_seats) from class_room a group by class;


but i'm not able to insert or update

insert into total_seats values('004','12','22');
error as target table total_seats of the INSERT is not insertable-into

or
update total_seats set No_of_seats=12 where class=11;
Error target table of the update is not updatable

i went through this website
https://dev.mysql.com/doc/refman/5.0/en/view-updatability.html[^]
but couldn't understand anything. please help me. how can i insert/update into a view.


Thanks in advance