Online Documentation for SQL Manager for MySQL
![]() |
Welcome to SQL Manager for MySQL! |
![]() |
What's new |
![]() |
System requirements |
![]() |
Feature matrix |
![]() |
Installation |
![]() |
Registration |
![]() |
How to register SQL Manager |
![]() |
Version history |
![]() |
EMS SQL Manager FAQ |
![]() |
Other EMS Products |
![]() |
Getting Started |
![]() |
Selecting style and language |
![]() |
First time started |
![]() |
Using Desktop Panel |
![]() |
Database navigation |
![]() |
Working with database objects |
![]() |
Using context menus |
![]() |
Host context menu |
![]() |
Database context menu |
![]() |
Object context menu |
![]() |
Working with windows |
![]() |
Database Explorer |
![]() |
Managing database registration info |
![]() |
Connecting to databases |
![]() |
Operations with database objects |
![]() |
Selecting multiple objects |
![]() |
Using tabs for database navigation |
![]() |
Recently opened objects |
![]() |
Managing Favorite objects |
![]() |
Searching within the tree |
![]() |
SQL Assistant |
![]() |
Configuring Database Explorer |
![]() |
Managing Favorite queries |
![]() |
Database Management |
![]() |
Create Database wizard |
![]() |
Setting database name |
![]() |
Setting connection properties |
![]() |
Viewing result SQL statement |
![]() |
Register Database wizard |
![]() |
Setting connection parameters |
![]() |
Specifying tunneling parameters |
![]() |
Selecting databases |
![]() |
Setting specific options |
![]() |
Database Registration Info |
![]() |
Connection |
![]() |
Common options |
![]() |
Display options |
![]() |
Default directories |
![]() |
Logs |
![]() |
SSH tunneling options |
![]() |
HTTP tunneling options |
![]() |
SSL |
![]() |
Data options |
![]() |
Find Option |
![]() |
Database Properties |
![]() |
Options |
![]() |
Objects summary |
![]() |
DDL |
![]() |
Database Registration Manager |
![]() |
Using Navigation bar and Toolbar |
![]() |
Database/Server Objects Management |
![]() |
New Object |
![]() |
Duplicate Object Wizard |
![]() |
Selecting the source database |
![]() |
Selecting object to duplicate |
![]() |
Selecting destination database |
![]() |
Specifying object details |
![]() |
Modifying the new object's definition |
![]() |
Database objects |
![]() |
Tables |
![]() |
New Table |
![]() |
Using Navigation bar and Toolbar |
![]() |
Setting table properties |
![]() |
Specifying fields |
![]() |
Partitions |
![]() |
Table Editor |
![]() |
Using Navigation bar and Toolbar |
![]() |
Managing fields |
![]() |
Changing fields order |
![]() |
Managing indexes |
![]() |
Managing foreign keys |
![]() |
Managing triggers |
![]() |
Working with table data |
![]() |
Table Properties |
![]() |
Setting storage options |
![]() |
MRG_MyISAM |
![]() |
Federated |
![]() |
Viewing table status |
![]() |
Fields |
![]() |
Field Editor |
![]() |
Setting field options |
![]() |
Editing ENUM and SET fields |
![]() |
Optimize Field Types Wizard |
![]() |
Selecting fields for analyzing |
![]() |
Selecting fields for type changing |
![]() |
Performing operation |
![]() |
Indices |
![]() |
Index Editor |
![]() |
Foreign Keys |
![]() |
Foreign Key Editor |
![]() |
Editing foreign key definition |
![]() |
Triggers |
![]() |
Using Navigation bar and Toolbar |
![]() |
Editing trigger definition |
![]() |
Views |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing view |
![]() |
Managing fields |
![]() |
Working with data |
![]() |
Stored Procedures |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing procedure |
![]() |
Specifying input parameters |
![]() |
Executing procedure/function |
![]() |
Stored Functions |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing function |
![]() |
Debugger |
![]() |
Using Navigation bar and Toolbar |
![]() |
Debugging |
![]() |
Viewing info |
![]() |
UDFs |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing UDF |
![]() |
Scheduled events |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing scheduled event |
![]() |
Local scripts |
![]() |
Server objects |
![]() |
Log file groups |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/Editing log file group |
![]() |
Tablespaces |
![]() |
Using Navigation and Toolbar |
![]() |
Creating/Editing Tablespace |
![]() |
Federated servers |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing federated server |
![]() |
Query Management Tools |
![]() |
SQL Editor |
![]() |
Using Navigation bar and Toolbar |
![]() |
Working with SQL Editor area |
![]() |
Using the context menu |
![]() |
Viewing query plan |
![]() |
Using object links |
![]() |
Executing queries |
![]() |
Viewing query logs |
![]() |
Favorites editor |
![]() |
Visual Query Builder |
![]() |
Using Navigation bar and Toolbar |
![]() |
Working with diagram area |
![]() |
Joining two objects |
![]() |
Setting criteria |
![]() |
Setting output fields |
![]() |
Setting grouping criteria |
![]() |
Setting sorting parameters |
![]() |
Working with the editor area |
![]() |
Query execution |
![]() |
Query parameters |
![]() |
Input parameters dialog |
![]() |
Data Management |
![]() |
Data View |
![]() |
Using Navigation bar and Toolbars |
![]() |
Grid View |
![]() |
Customizing columns |
![]() |
Grouping and sorting data |
![]() |
Filtering records |
![]() |
Using the context menu |
![]() |
Working in multi-level mode |
![]() |
Create Grid Level wizard |
![]() |
Specifying master level |
![]() |
Defining source for detail level |
![]() |
Binding master and detail levels |
![]() |
Query parameterization |
![]() |
Setting additional parameters |
![]() |
Working in card view mode |
![]() |
Column Summary |
![]() |
Copying records |
![]() |
Form View |
![]() |
Print Data |
![]() |
Page Setup |
![]() |
Page |
![]() |
Margins |
![]() |
Header/Footer |
![]() |
Scaling |
![]() |
Report Formatter |
![]() |
View |
![]() |
Behaviors |
![]() |
Formatting |
![]() |
Styles |
![]() |
Preview |
![]() |
Cards |
![]() |
Charts |
![]() |
Setting report options |
![]() |
Print dialog |
![]() |
BLOB View |
![]() |
Navigation within BLOB Editor |
![]() |
Editing as Hexadecimal |
![]() |
Editing as Text |
![]() |
Editing as Rich Text |
![]() |
Editing as Image |
![]() |
Editing as HTML |
![]() |
Editing as XML |
![]() |
Editing as JSON |
![]() |
Applying changes |
![]() |
Custom Filter |
![]() |
Filter Builder dialog |
![]() |
Invoking the Filter Builder dialog |
![]() |
Adding a new condition |
![]() |
Setting filter criteria |
![]() |
Setting filter operator |
![]() |
Setting filter criteria values |
![]() |
Adding a new group |
![]() |
Setting group operator |
![]() |
Applying filter conditions |
![]() |
Import/Export Tools |
![]() |
Export Data Wizard |
![]() |
Setting destination file name and format |
![]() |
Selecting fields for export |
![]() |
Adjusting data formats |
![]() |
Setting header and footer |
![]() |
Setting format-specific options |
![]() |
Excel 97-2003 options |
![]() |
Data format |
![]() |
Fields |
![]() |
Options |
![]() |
Styles |
![]() |
Extensions |
![]() |
Hyperlinks |
![]() |
Notes |
![]() |
Charts |
![]() |
Cells |
![]() |
Merged Cells |
![]() |
Advanced |
![]() |
Access options |
![]() |
Word 97-2003 / RTF options |
![]() |
Base styles |
![]() |
Strip styles |
![]() |
HTML options |
![]() |
Preview |
![]() |
Basic |
![]() |
Multi-file |
![]() |
Advanced |
![]() |
PDF options |
![]() |
TXT options |
![]() |
CSV options |
![]() |
XML options |
![]() |
MS Excel / ODS options |
![]() |
MS Word / ODT options |
![]() |
Setting common export options |
![]() |
Exporting data |
![]() |
Import Data Wizard |
![]() |
Selecting source file name and format |
![]() |
Selecting data source |
![]() |
Setting fields correspondence |
![]() |
Excel |
![]() |
Access, DBF, XML |
![]() |
TXT |
![]() |
CSV |
![]() |
HTML |
![]() |
XML Generic |
![]() |
MS Excel/Word 2007, ODF |
![]() |
Adjusting data formats |
![]() |
Setting advanced field formats |
![]() |
Setting import mode |
![]() |
Customizing common options |
![]() |
Importing data |
![]() |
Export as SQL Script |
![]() |
Selecting destination DBMS |
![]() |
Setting destination file name |
![]() |
Setting BLOB options |
![]() |
Selecting fields to export |
![]() |
Setting export options |
![]() |
Editing result SQL script |
![]() |
Exporting as SQL Script |
![]() |
Save Data Wizard |
![]() |
Setting destination file name |
![]() |
Selecting fields for saving |
![]() |
Specifying data format parameters |
![]() |
Saving data |
![]() |
Load Data Wizard |
![]() |
Setting source file name |
![]() |
Selecting processing parameters |
![]() |
Selecting fields for loading |
![]() |
Specifying data format parameters |
![]() |
Loading data |
![]() |
Export as PHP wizard |
![]() |
Specifying destination file |
![]() |
Selecting fields to export |
![]() |
Adjusting formats for exported fields |
![]() |
Defining headers and footers of the result file |
![]() |
Performing operation |
![]() |
Database Tools |
![]() |
Common DB Tools |
![]() |
Dependency Tree |
![]() |
Using Navigation bar and Toolbar |
![]() |
Viewing dependency tree |
![]() |
SQL Monitor |
![]() |
Using Navigation bar and Toolbar |
![]() |
Working with SQL Monitor |
![]() |
SQL Script Editor |
![]() |
Using Navigation bar and Toolbar |
![]() |
Working with SQL Script editor area |
![]() |
Using Script Explorer |
![]() |
Script execution |
![]() |
Extract Database Wizard |
![]() |
Selecting source database |
![]() |
Specifying destination file name |
![]() |
Setting extraction mode |
![]() |
Selecting database objects for structure extraction |
![]() |
Selecting server objects to extract |
![]() |
Selecting objects for data extraction |
![]() |
Customizing script options |
![]() |
Start of extraction process |
![]() |
Print Metadata |
![]() |
Using Navigation bar and Toolbar |
![]() |
Printing options |
![]() |
Print Preview |
![]() |
HTML Report Wizard |
![]() |
Selecting database and directory |
![]() |
Selecting database object types |
![]() |
Selecting server object types |
![]() |
Specifying CSS |
![]() |
Setting additional report options |
![]() |
Creating HTML report |
![]() |
Reports management |
![]() |
Create Report Wizard |
![]() |
Specifying database name and report options |
![]() |
Selecting report bands |
![]() |
Selecting report style |
![]() |
Specifying page settings |
![]() |
Specifying paper settings |
![]() |
Specifying margins |
![]() |
Specifying other page settings |
![]() |
Report Designer |
![]() |
Adding dialog form |
![]() |
Adding database and query components |
![]() |
Adding report data |
![]() |
Viewing the report |
![]() |
Saving the report |
![]() |
Report Viewer |
![]() |
Using Navigation bar and Toolbar |
![]() |
Search in Metadata |
![]() |
Using Navigation bar and Toolbar |
![]() |
Setting search conditions |
![]() |
Viewing search results |
![]() |
Visual Database Designer |
![]() |
Using Navigation bar and Toolbars |
![]() |
Using Diagram Navigator and DB Objects pane |
![]() |
Using context menus |
![]() |
Working with diagram objects |
![]() |
Adding/removing objects to/from diagram |
![]() |
Incremental search |
![]() |
Creating objects |
![]() |
Creating relations |
![]() |
Working with diagram pages |
![]() |
Reverse engineering |
![]() |
Printing diagram |
![]() |
Print Preview |
![]() |
Print Setup dialog |
![]() |
Saving/loading diagram |
![]() |
Setting diagram options |
![]() |
Specific DB Tools |
![]() |
Compare Databases Wizard |
![]() |
Selecting source database |
![]() |
Specifying target database |
![]() |
Selecting type of synchronization script |
![]() |
Defining options for destination script |
![]() |
Performing operation |
![]() |
Copy Database Wizard |
![]() |
Selecting source database |
![]() |
Specifying destination database |
![]() |
Selecting components to copy |
![]() |
Selecting objects to copy their structure |
![]() |
Selecting server objects to copy |
![]() |
Selecting objects to copy their data |
![]() |
Setting additional options |
![]() |
Copying database |
![]() |
Show information |
![]() |
Using Navigation bar and Toolbar |
![]() |
Show host information |
![]() |
Show database information |
![]() |
Server Tools |
![]() |
Dump Database |
![]() |
Specifying source host |
![]() |
Selecting databases to dump |
![]() |
Selecting objects to dump |
![]() |
Specifying destination file name |
![]() |
Setting dump options |
![]() |
Setting structure options |
![]() |
Setting data options |
![]() |
Performing operation |
![]() |
Restore Database |
![]() |
Specifying host |
![]() |
Selecting file for restoring |
![]() |
Selecting databases |
![]() |
Selecting objects |
![]() |
Performing operation |
![]() |
Backup Tables |
![]() |
Selecting database |
![]() |
Selecting tables for backup |
![]() |
Viewing routine results |
![]() |
Restore Tables |
![]() |
Setting the source directory |
![]() |
Selecting target database |
![]() |
Selecting tables for restoring |
![]() |
Viewing routine results |
![]() |
Flush |
![]() |
Flush usage |
![]() |
Analyze Tables |
![]() |
Selecting database |
![]() |
Selecting tables for analyzing |
![]() |
Viewing routine results |
![]() |
Check Tables |
![]() |
Selecting database |
![]() |
Selecting tables for checking |
![]() |
Viewing routine results |
![]() |
Repair Tables |
![]() |
Selecting database |
![]() |
Selecting tables for repairing |
![]() |
Viewing routine results |
![]() |
Optimize Tables |
![]() |
Selecting database |
![]() |
Selecting tables for optimizing |
![]() |
Viewing routine results |
![]() |
Truncate Tables |
![]() |
Selecting database |
![]() |
Selecting tables for truncating |
![]() |
Viewing routine results |
![]() |
Change Tables Engine |
![]() |
Selecting host and database |
![]() |
Selecting tables |
![]() |
Viewing routine results |
![]() |
Server Properties |
![]() |
Using Navigation bar and Toolbar |
![]() |
Viewing status variables |
![]() |
Viewing system variables |
![]() |
Viewing process list |
![]() |
Viewing InnoDB status |
![]() |
Viewing general query log |
![]() |
Instance Manager |
![]() |
Starting/Stopping Service |
![]() |
Configuring Service |
![]() |
Run mysql.exe |
![]() |
Ping Server |
![]() |
Shutdown Server |
![]() |
Server security management |
![]() |
User Manager |
![]() |
Using Navigation bar and Toolbar |
![]() |
Managing users |
![]() |
User Editor |
![]() |
Grant Manager |
![]() |
Using Navigation bar, Toolbar and context menu |
![]() |
Managing global privileges |
![]() |
Managing database-specific privileges |
![]() |
Managing column permissions |
![]() |
Filtering objects in list |
![]() |
Options |
![]() |
Environment Options |
![]() |
Preferences |
![]() |
Full mode activation |
![]() |
Confirmations |
![]() |
Appearance |
![]() |
Tools |
![]() |
Timeouts |
![]() |
DB Explorer |
![]() |
Search |
![]() |
Table Editor |
![]() |
SQL Editor |
![]() |
SQL Monitor |
![]() |
SQL Script |
![]() |
Query Builder |
![]() |
Style & Color Palette |
![]() |
Visual Database Designer |
![]() |
Print Metadata |
![]() |
Data Export |
![]() |
Server Properties |
![]() |
Fonts |
![]() |
Grid |
![]() |
Data Options |
![]() |
Print Data |
![]() |
Color & Formats |
![]() |
Advanced |
![]() |
Column Options |
![]() |
Localization |
![]() |
Global Shortcuts |
![]() |
Find Option |
![]() |
Editor Options |
![]() |
General |
![]() |
Display |
![]() |
Color Scheme |
![]() |
Code Completion |
![]() |
SQL Formatter |
![]() |
SQL words |
![]() |
Key Mapping |
![]() |
Spell Checking |
![]() |
Find Option |
![]() |
Save Settings |
![]() |
Specifying destination file |
![]() |
Selecting settings |
![]() |
Selecting databases |
![]() |
Saving settings |
![]() |
Object Templates |
![]() |
Table subobjects |
![]() |
Localization |
![]() |
Localization Editor |
![]() |
Select Program Language |
![]() |
Keyboard Templates |
![]() |
Find Option dialog |
![]() |
External tools |
![]() |
External Tools dialog |
![]() |
External Tool Info editor |
![]() |
How To... |
![]() |
Work with Databases |
![]() |
Connect to a database |
![]() |
Create a database |
![]() |
Edit database connection parameters |
![]() |
Make work with a database faster |
![]() |
Design a visual database structure |
![]() |
View an ER diagram |
![]() |
Create a database copy |
![]() |
Document a database |
![]() |
Save metadata reports to file |
![]() |
Log database changes |
![]() |
Get an SQL dump |
![]() |
Synchronize two databases |
![]() |
Work with Database Objects |
![]() |
Group objects |
![]() |
Find objects |
![]() |
View dependecies |
![]() |
Get an object DDL |
![]() |
Work with Data |
![]() |
View tables with many records |
![]() |
Set data filter |
![]() |
Sort and group data |
![]() |
Export/import data |
![]() |
Export filtered data |
![]() |
Export data as SQL Script |
![]() |
Edit data of master-detail tables |
![]() |
Add image to table |
![]() |
Set data display format |
![]() |
Work with Queries and Scripts |
![]() |
Create SQL statements rapidly |
![]() |
Control a query productivity |
![]() |
Work with several queries at once |
![]() |
Save most frequently used queries |
![]() |
Execute queries with parameters |
![]() |
Export query results into file |
![]() |
Execute scripts |
![]() |
Execute a large SQL script |
![]() |
Make SQL script work faster |
![]() |
Customize work with Query/Script text |
![]() |
View executed queries and scripts |
![]() |
Manage privileges |
![]() |
Prevent connection timeout |
![]() |
Connect to hosting provider's database |
![]() |
Create a simple report in Report Designer |
![]() |
Transfer program settings |
![]() |
Update SQL Manager |
![]() |
Report bugs and suggestions |
![]() |
Appendix |
![]() |
Program interface |
![]() |
Viewing object DDL structure |
![]() |
Editing object description |
![]() |
Browsing object dependencies |
![]() |
Changing Metadata window |
![]() |
Find Text dialog |
![]() |
Replace Text dialog |
![]() |
Format specifiers |
![]() |
Language Info Editor |
![]() |
Using templates |
![]() |
Supported file formats |
![]() |
To-Do List |
![]() |
Windows List |
![]() |
Customize toolbars and menus |
![]() |
SSH tunneling options |
![]() |
HTTP tunneling options |
![]() |
SQL Manager Direct |
![]() |
Login Host / Database Login dialogs |
![]() |
Overwriting existing output file |
![]() |
Script conversion |
![]() |
Storage engines reference |
![]() |
Select Object dialog |
![]() |
SQL Manager shortcuts |
© 1999-2025 EMS Software Development