Is there any way to insert data into multiple tables through a view in mysql?
The MySQL Reference Manual says this about updatable views:
Some views are updatable. That is, you can use them in statements such as
INSERTto update the contents of the underlying table. For a view to be updatable, there must be a one-to-one relationship between the rows in the view and the rows in the underlying table. There are also certain other constructs that make a view nonupdatable.
WITH CHECK OPTIONclause can be given for an updatable view to prevent inserts or updates to rows except those for which the
WHEREclause in the select_statement is true. The
WITH CHECK OPTIONclause was implemented in MySQL 5.0.2.
You can find the entire article here.