Tuesday, February 27, 2024
HomeHow ToDesigning Views with MySQL Query Builder

Designing Views with MySQL Query Builder

If you often need to create and modify views in your MySQL development you will like dbForge Studio for MySQL in-place query editing feature. This feature allows integration of powerful Query Builder tool with view editor without annoying copy/paste.

Suppose you have previously created view with some SELECT statement. To view and design this statement with Query Builder you need to perform these steps:

  1. Open view editor.
  2. Right-click on SELECT statement.
  3. In pop-up menu select ‘Design SQL…’ command.
  4. In opened Query Builder re-design you SELECT statement (See picture below).
  5. After you click OK new statement automatically gets pasted into the view  editor.

If you need to design new SELECT statement when you are creating view use ‘Insert SQL…’ command.

Pop-up Query Builder
Pop-up Query Builder