Using WinMySQL Professional

New MySQL® view

Only accessible when connected, the «File>New>MySQL® view» submenu allows to create a clause file to filter tables. It is very useful when you wish to handle big tables.

The *.mvf clause file will be added to all the tables management queries in order to dynamically work on a table extract.

How to create a view ?

First, invoke the «File>New>MySQL® view» submenu : a table list appears. Choose the table on which you wish build a view.

Then, in the «Create view» screen, select the related colum name in the combobox «Column name».

Select the arithmetic operator in the «Operators» combobox.

Enter the value to be compared with the column content into the «Clause value» box. Don't add any quote.

Then click on the «Add clause» button.

If you wish to add other clauses, you must select «Or» or «And» in the «Clause link» combobox and

click on the «New clause» button. Then, repeat a clause creation until the «Add clause» button step.

To generate a view file, just click on the «Save view» button.

If SQL is easy for you, you may yourself write your clauses (for instance with parenthesis, with the «like» operator ...) or you may edit which is already generated, just checking the «Manual clauses edition» checkbox. The content of the clauses editor must respect the SQL syntax after the «where» statement of a query.