The fields in a view are fields from one or more real tables in the database. in the underlying table. If you have multiple users updating the settings table and running the view concurrently things could go wrong, but otherwise it should work OK. Something like: no. which is the same as the owner of the view's schema, gets MERGE, TEMPTABLE, or Materialization, Section13.1.18.7, CREATE TABLE and Generated Columns, Section23.5.3, Updatable and Insertable Views, Section23.5.4, The View WITH CHECK OPTION Clause. Then don't use a view at all, if you need exact control build the entire query every time, or build the query inside a stored procedure. Need a MySQL workaround to pass a variable \ parameter into view? Then to use the view to choose the 32-value items you want, do this: If your table is large, this view might be faster if you use UNION ALL in place of UNION. for underlying views to be evaluated as well. To create the view explicitly in a given database, use a fully qualified name. mysql - Views with parameters, is it possible? - Database invoke the function can be checked. but the effect is undefined. to tables or views in other databases by qualifying the table or How a top-ranked engineering school reimagined CS curriculum (Ep. in Microsoft Access linked tables/views) and write the updates back to the database. referenced by the view. However, in my experience, MySQL does not do a great job of pushing predicates inside views, so the performance will likely suffer. There is just a small change in the format of the command. How to use MySQL VIEW with WHERE clause - TutorialsPoint When your stored query returns the column where you want to filter with, you can do it in the calling query. Connect and share knowledge within a single location that is structured and easy to search. easy and functional! The number of names in When using parameters it is not possible to do this because a Which language's style guidelines should be used when writing code that is supposed to be called from another language?