Statement Expansion

Wildcard expansion

This feature allows you to replace the asterisk (*) symbol with the list of columns from the required table or view on pressing the TAB key.

Inserting columns list on pressing TAB

You may insert a list of columns available for the needed objects (tables, views, etc.) of the FROM list instead of the * symbol by pressing the TAB key. If such list can be inserted, a hint is displayed when the cursor is after the * symbol.

Expanding INSERT and ALTER statements

This feature saves much time for users as it allows them to type just available table names, views or events in the ALTER and INSERT statements and expand the statement to the full template by pressing the TAB key.

Expanding the ALTER VIEW statement

  1. Start typing the ALTER VIEW statement. Select actor_info from the appeared suggestion list. Press ENTER.

  2. The TAB key hint appears.

  3. Press TAB to display the view definition.

Execute current statement

You can execute a current SQL statement without selecting it. You just need to place the cursor in the statement, and press F8 - dbForge Studio will define statement boundaries itself.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for MySQL?
Download a free 30-day trial