A view works as a virtual table that is used to store query and returns a result set when it is called. An updatable view is also supported by MySQL.