I am able to create a view for retrieving the records based on some criteria, but does the view only support for retrieving the records or will it support for delete and update the records in the tables.
create view onlinetestview as select * from onlinetest where experience = '1-2 Years'
I used the above view its working fine but when i am trying to create a view for updating the table record its giving me an error:
create view onlinetestview2 as update onlinetest set experience='1-2Years' where experience='1-2 Years';
The error is : Lookup Error - MySQL Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update onlinetest set experience='1-2Years' where experience='1-2 Years'' at line 1