view based on joins

Hi, Senthil

Is it possible in mysql server?

As per as my knowledge as concerned, it is not possible to insert. If view belongs to one table then it can be possible. Because the sql server views do not have the mechanism to classify the referential integrity while insert into the view when it has multiple tables.

Satyapriya Nayak14y ago

Hi Arjun,

Please refer the below link

http://www.codeproject.com/Articles/236425/How-to-insert-data-using-SQL-Views-created-using-m?display=Print

Thanks