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 |
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-2024 EMS Software Development