Is it possible to insert data in DataBase through View.

Question

Bhavna Chaudhri · Answer

when you insert data into views your table will also be updated.

Rajanikant Hawaldar · Answer

Hello Shailendra Kumar, Please try as below. first create table as below example. CREATE TABLE STUDENT( STD_ID INT , STD_FNAME VARCHAR (20), STD_LNAME VARCHAR (20) ) Then create following view CREATE VIEW VW_STUDENT AS SELECT STD_ID, STD_FNAME, STD_LNAME FROM STUDENT 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. INSERT INTO VW_STUDENT SELECT 1, 'Peter' , 'Parker' UNION SELECT 2, 'James' , 'Watson' after executing above navigate to table and verify.

Sachin Singh · Answer

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.

Shailendra Kumar · Answer

Thankyou Rajanikant Hawaldar ji for very simle code.

Is it possible to insert data in DataBase through View.

Answers (4)