Including Columns in Query
To use a column in a query, you must add it to the query. You may add a column to display it in query output, to use it for sorting, to search the contents of the column, or to summarize its contents.
To add an individual column
- In the Diagram Pane, select the check box next to the column that you want to include.
Alternatively
- In the Tabbed Editor, move to the first blank grid row, click the field in the Column column, and select a table and a column name from the drop-down list.
To add all columns for one table or table-valued object
- In the Diagram Pane, select the check box next to (All Columns).
To add all columns for all tables and table-structured objects
- In the Design Pane, select all tables.
- Make sure no join lines in the Design Pane are selected.
- Right-click any table and select Select all columns on the shortcut menu.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
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?