Can a record be inserted into a view?
If it can, will inserting a record cause MySQL MAX to distribute the values correctly into the related tables?
So if I have the following view:
bookPulling from related tables:
INSERT INTO all_books (author_name,author_last_name,publisher,title) VALUES ("John","Smith","Barnes and Nobles","Book title")...insert "John" into author.name, "Smith" into author.last_name, "Barnes and Nobles" into publisher.name and "Book title" into book.title while setting the appropriate FK?
Hope I explained it right...