CODEWITHSUNDEEP
mysqlsql
rockstardev
rockstardev

Reputation: 13537

When creating a view in MySQL, can update commands be run on that view?

I am creating a HUGE query with 5 or 6 join, and want to turn this into a view. But, I need too be able to update this view. Is this possible?

By update, I mean, run an SQL UPDATE command, alter a value, and then let the changed values filter through to the appropriate tables.

Upvotes: 1

Views: 137

Answers (1)

Pete OHanlon
Pete OHanlon

Reputation: 9146

Certain views can be updatable in MySQL, but there are constraints with them. At the very least, there must be a 1 to 1 relationship between the rows in the view and the rows in the underlying table.

Upvotes: 3

Related Questions