Au contraire, there are no effects of changing a table’s structure on a dependent view in MySQL! I’ve heard that other databases like Oracle automatically pick up changes on the table’s structure, but in MySQL the view is frozen upon creation.
If you expect to do
it sure is going to fail.
Solution: Either drop the view and recreate it:
or alter the view:
Lesson: Do not forget about the dependent views when you change a table’s structure!