I have a VIEW that is defined over two base tables. One table is subtype of another table and it's the VIEW that connects them. Now when I want to insert into a subtable I have to insert through the VIEW. However I am getting an error message when I try to insert into a VIEW. I found the solution to this problem using the TRIGGER with "INSTEAD OF" but that was from one of the Oracle discussions, and that works only with Oracle. As far as I know MySQL does not support "INSTEAD OF", and my question is does MySQL support INSERTS into VIEW? Or is there some way I can insert into a view?
Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
