Insertion using views in MySQL MAX.

[lgomez]

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:

book


====
author_name
author_last_name
publisher
title

Pulling from related tables:

author

=====
id
name
last_name

book
=====
id
title

publisher
======
id
name
number

will doing:

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...

Thank you,

[r937]

yes, you explained it fine

i don't think any database does that