Using WinMySQL Professional

Open MySQL® view

Only accessible when connected, the «File>Open>MySQL® view» submenu allows to dynamically filter tables to work on an extract such as it was a real table. It is very useful when you wish to handle big tables.

To open a view, just invoke the «File>Open>MySQL® view» submenu . You will be prompted to choose a *.mvf file. Obviously, if you choose an improper view file (with clauses relating columns of another table), the opening will fail with a transaction error message.

Warning ! The view feature is just a client-side simulation in order to manage big tables with WinMySQL Professional features. Even with a view opened, manual queries sent with the pseudo-terminal won't be filtered.

This menu can be invoked by the shortcut «Ctrl-V».