Is it possible to insert data in DataBase through View.

views are nothing but saved sql query , people also term it as virtual table but it is not it is just saved sql query which refers to the original table every time you query your view.

so when you insert data in view , yes your original table will also be updated , but if your view uses joins then the case is not the same.

as @Rajnikant sir stated when you insert data in your view it will reflect in your original table.

Hello Shailendra Kumar, Please try as below. first create table as below example.

Then create following view

Now you can insert data to the above table using the views we have just created. And it is the same syntax that we use to insert data to tables.

after executing above navigate to table and verify.