title: How do i update mysql views when a column is added/deleted from the table?
body: <p>I created a table and then some views for the table. Now i altered the table to add another column in it.But the views are not updated.It doesn't have the column that is added in the table.Is there any way to modify view structure automatically?</p>