dbForge Studio for MySQL
Documentation center
Download trial

  • Table of Contents

  • Get started
    • Requirements and compatibility
    • Installation
      • How to install dbForge Studio
      • Installation from the command line
    • Copyright information
    • How to run dbForge Studio on Linux & macOS
      • Using CrossOver
        • How to install dbForge Studio on Linux & macOS
        • Scenario-based installation of dbForge Studio via CrossOver
        • Manual installation of dbForge Studio via CrossOver
        • Troubleshooting installation issues
        • Command-line mode on Linux
        • Command-line mode on macOS
        • How to schedule recurring tasks on macOS via cron
      • Using Wine
        • Install the Studio on Ubuntu
    • Third-party software
    • Updates
    • Creating and editing a query
    • Connecting to a database
    • Creating a query in Query Builder
    • Editing data
    • Creating a table in Table Editor
    • Backup a database
    • Data storage and transmission policy
    • Licensing and activation
      • Licensing
      • Activating dbForge Studio for MySQL
      • Deactivation
  • Connecting to Databases
    • Connecting to Amazon RDS
    • MySQL Database Browser for Windows
    • Managing Database Connections
    • Advanced Settings for Database Connections
    • Creating SSH Connection
    • Creating SSL Connection
    • Generating Certificates for MySQL Server and SSL Client
    • Installing and Setting Up SSH Server
    • Setting Up HTTP tunneling
    • Uploading the Tunneling Script
    • Working with Embedded Server
    • Viewing Database Schema Information
    • Connect to Amazon RDS using IAM database authentication
    • How dbForge Studio for MySQL is involved in the DevOps process
  • Documenting MySQL Databases
    • Generating Database Document
    • Documenting Databases through the Command Line
    • Exit Codes used in Command Line for /document
  • Writing and Executing SQL Statements
    • SQL Document Overview
    • Writing SQL Statements
    • Executing SQL Statements
    • Viewing Server Messages and Errors
    • Statement Expansion
    • Using Parameters
    • SQL Query History
    • Execution Warnings
    • Executing Large Scripts
    • Opening Large Scripts in SQL Editor
    • Associating Windows with Connection
    • SQL Document Shortcut Keys
    • Working with Literals
    • Working with Code Snippets
    • Phrase Completion
    • Executing Scripts through the Command Line
    • Exit Codes used in Command Line for /execute
    • Formatting Code through the Command Line
    • Exit Codes used in Command Line for /formatsql
  • Building Queries with Query Builder
    • Query Builder Overview
    • Adding Tables to Query
    • Removing Tables from Query
    • Including Columns in Query
    • Making Joins Between Tables
    • Building WHERE or HAVING Clause
    • Including Fields in GROUP BY or ORDER BY Clauses
    • Building a Query in Visual Mode
    • Working with Different Query Types
    • Navigating Query with Document Outline
    • Diagram Overview
    • Diagram Layout
    • Aligning Shapes
    • Changing Shape Size
    • Controlling Spacing between Shapes
    • Diagram Shortcuts Overview
    • Focus and Selection Shortcuts
    • Zoom and Scroll Shortcuts
    • Shape and Column Managing Shortcuts
    • Subqueries Overview
    • Subqueries in From Clause
    • Subqueries in Other Clauses
  • Working with Data in Data Editor
    • Viewing Data in Grid Overview
    • Sorting Data in Grid
    • Grouping Data in Grid
    • Filtering Data in Grid
    • Server-Side and Client-Side Sorting and Filtering
    • Paginal Mode
    • Auto-Search Mode
    • Card View
    • Editing Data in Grid Overview
    • Cached Updates
    • Foreign Key Lookup
    • Data Shortcut Keys
    • Inserting and Retrieving Data
    • Possible Issues with Data Editor
  • Working with Data Generator
    • Setting Up Data Generator
    • Using Generators
    • Generating Data for Empty Database
    • Populating Database
    • Creating Custom Generators
    • Generating Data through the Command Line
    • Exit Codes Used in Command Line for /generatedata
  • Exporting and Importing Data
    • Data Export Overview
    • Exporting Data
    • Setting up data export to CSV format
    • Saving and Using Templates During Data Export
    • Exporting Data through Command Line
    • Additional /dataexport Arguments
    • Exit Codes Used in Command Line for /dataexport
    • Data Import Overview
    • MS Access Import
    • CSV Import
    • MS Excel Import
    • Google Sheets Import
    • Text Import
    • JSON Import
    • XML Import
    • Importing Data to a New Table
    • Saving and Using Templates During Import
    • Migrating Data from Other Servers
    • Importing Data through Command Line
    • Additional /dataimport Arguments
  • Data Analysis
    • What is Pivot Table?
    • Creating a Pivot Table
    • Creating a Chart in Pivot Table
    • Reordering Fields
    • Filtering Fields
    • Sorting Fields
    • Grouping Fields
    • Using Summary Functions to Calculate Custom Totals
    • Applying Conditional Styles
    • Printing
    • Areas
    • Headers
    • Filter Field
    • Column Field
    • Row Field
    • Data Field
    • Totals
    • Grand Totals
  • Viewing Data in Master-Detail Tables
    • Viewing Data in Related Tables
    • Working with Self-Referencing Tables in Master-Detail Browser
    • Working with Master-Detail Browser Document
    • Sorting and Filtering Data in Master-Detail Browser
    • Tips for Working with Master-Detail Browser
  • Working with Database Objects
    • Creating and Dropping Databases
    • Creating a Database Object
    • Creating a Copy of a Database Object
    • Displaying the Number of Database Objects
    • Creating, Viewing, Dropping, and Editing Tables
    • Defining Table Structure
    • Managing MySQL Primary Keys
    • Managing MySQL Foreign Keys
    • Partitioning Methods
    • Creating Partitioned Tables
    • Adding or Removing Partitions or Subpartitions
    • Merging Tables
    • Using FEDERATED Tables
    • Working with Views
    • Generating DDL Statements for Database Objects
    • Working with Stored Programs
    • Viewing Object Dependencies
    • Performing Refactoring of Database Objects
    • Performing Refactoring in SQL Script
    • Refactoring Overview
    • Refactoring Usage
    • Creating a Database and Two Tables
    • Creating a View
    • Creating a Trigger
    • Creating Scripts Folder with Static Data
    • Finding Invalid Objects
  • Working with Search
    • Searching Database Objects
    • Searching Table and Viewing Data
    • Managing Search Results
  • Designing Databases with Database Designer
    • Creating a Database Diagram
    • Adding Database Objects to a Diagram
    • Deleting or Editing Database Object on a Diagram
    • Creating a Many-to-Many Relationship Between Tables
    • Saving and Restoring a Diagram
    • Exporting a Diagram
    • Printing a Diagram
    • Searching Text on the Database Diagram
    • Setting Diagram Options
    • Why Relation Cannot Be Created?
    • Additional Elements on a Diagram
    • Editing Tables
    • Displaying Database Objects on a Diagram
    • Working with Relations
    • Relation Notations
    • Diagram Shapes and Layout
  • Backup and Restore of MySQL Databases
    • Database Backup and Restore
    • Scheduling Database Backup
    • /backup Arguments
    • Exit Codes Used in Command Line for /backup
    • /restore Arguments
    • Exit Codes Used in Command Line for /restore
  • Managing Users and Privileges
    • Manipulating User Accounts
    • Manipulating Roles
    • Granting and Revoking Roles
    • Granting and Revoking Global Privileges
    • Granting Privileges on Database Objects
    • Working with Multiple Users
    • Watermarks in Security Manager
    • How to check the account that the SQL Server Agent is using
  • Debugging Stored Routine
    • Debugger Overview
    • Debug a stored procedure
    • Debug a MySQL function
    • Debugging Trigger
    • Debugging SQL Script
    • Working with Breakpoints
    • Execution Control
    • Debugging Engine
    • Debugging Shortcut Keys
    • Sample Script for Creating Database Tables
    • FAQ about Debugger for MySQL
  • Optimizing SQL Queries
    • Getting Query Profiling Results
    • Comparing Query Profiling Results
  • Comparing and Synchronizing Database Schemas
    • Synchronizing Two Schemas
    • Saving and Loading Schema Comparison
    • Setting up Schema Comparison
    • Group and filter comparison results
    • Comparing Objects' DDL
    • Previewing Schema Synchronization Script
    • Generating Comparison Report
    • Synchronizing Schemas
    • Comparing and Synchronizing Schemas through Command Line
    • Switches used in the command line
    • Command Line Options for /schemacompare
    • Exit Codes Used in Command Line for /schemacompare
    • Schema Comparison and Synchronization Overview
    • Viewing Schema Differences Overview
    • Comparing and Synchronizing Schemas on Different MySQL Server Versions
    • Minimum Rights Required to Compare Schemas
    • Automate schema comparison between a scripts folder and a database
  • Comparing and Synchronizing Data in Databases
    • Setting up Data Comparison
    • Mapping Tables and Views
    • Mapping Columns
    • Setting Comparison Key
    • Filtering Rows Included into Comparison
    • Mapping Warnings
    • Data Comparison Options
    • Type Compatibility Table
    • Viewing Data Comparison Results
    • Generating Data Comparison Report
    • Synchronizing Data
    • Synchronization Warnings
    • Synchronization Error Handling
    • Automatic data comparison and synchronization from the command line
    • Scheduling Database Synchronization
    • Switches used in the command line
    • Options Used in Command Line for /datacompare
    • Parameters Used in Connection String
    • Exit Codes Used in Command Line for /datacompare
    • Known Data Comparison Problems
    • Data Comparison Process Overview
    • Data Synchronization Process Overview
  • Copy Databases
    • Copying Databases
    • Copying Databases through the Command Line
    • Options Used in Command Line for /copydatabase
    • Exit Codes Used in Command Line for /copydatabase
  • Performing Administration Tasks
    • Controlling Server Variables
    • Managing Services
    • Controlling Sessions
    • Performing Maintenance and Flush Operations
  • Developing Database Projects
    • Database Project Overview
    • Creating and Opening Projects
    • Managing Files in Projects
    • Working with Database Objects in Project
    • Using Project Build Configurations
    • Building and Deploying Project
    • Working with Project
    • Comparing Schema and Project
    • Sample Project
    • Project Connection
    • Manipulating Database Object Shortcuts
    • Project Build Overview
    • Project and Schema Synchronization Overview
    • Comparing Schema and Project Peculiarities
    • Applying Project Options When Synchronizing a Project and a Schema
  • Writing Data Reports
    • Creating a Static Report
    • Creating a Simple Data-Aware Report
    • Creating a Master-Detail Report
    • Saving and Loading Reports
    • Exporting Data Reports to Various Formats
    • Automating MySQL reports using Command Line
    • Additional /datareport Arguments
    • Exit Codes used in Command Line for /datareport
    • MySQL Data Reports Overview
    • Report Building Basics
    • Designer Elements
    • Measure Units
    • Report Bands
    • Report Controls
    • Smart Tags
    • Context Links
    • Sample Reports
  • User Interface Concepts
    • Using Documentation
    • User Interface Elements
    • Manipulating Documents
    • Working with SQL Editor
    • Customizing Window Layout
    • Customizing Environment
    • Importing and Exporting Settings Overview
    • Import, Export, or Reset Settings
    • Finding and Replacing Text
    • Searching and Replacing Text in Files
    • Using Incremental Search
    • Regular Expressions for Find and Replace
    • Wildcards for Find and Replace
  • Source-Controlling Databases
    • Set up a source control system
    • Link to Source Control
      • Link a MySQL database to Git repositories
        • Link a database to a Git repository
        • Link a database to a Git repository in GitHub
        • Link a database to a Git repository in Azure DevOps
        • Link a database to a Git repository in BitBucket
        • Link a database to a Git repository in GitLab
      • Link to other version-control systems
        • Link a database to TFVC
        • Link a database to a Subversion (SVN) repository
        • Link a database to a SourceGear Vault repository
        • Link a database to a Perforce repository
        • Link a database to a Mercurial repository
        • Link a database to Plastic SCM and other systems
    • Link a database to a working folder
    • Unlink a database from source sontrol
    • Use development models for teams
      • Dedicated model
      • Shared model
    • Work with Source Control
      • Commit changes
      • Undo changes
      • Get the latest version
      • Resolve conflicts
      • Link and unlink static data
      • View Source Control history
    • Work with branches
      • Switch between branches
      • Merge branches
    • Work with particular cases
      • Update to a specific revision from Source Control
      • Deploy a database from version control
      • Generate a migration script
      • Deploy changes to databases
      • Troubleshooting
        • How to resolve the Git issue - Author identity unknown
        • How to resolve the Git issue - There is no tracking information for the current branch
        • How to resolve the Git issue - Ignoring dangling symref head
        • How to resolve the TFVC issue - No folder on the repository
      • Version-control database changes
  • Creating Command-Line Execution File
    • How to Create a Command-Line Execution File
  • Release notes and other versions
    • dbForge Studio for MySQL release history
    • What's New in Studio for MySQL v10.1
    • What's New in Studio for MySQL v10.0
    • What's New in Studio for MySQL v9.2
    • What's New in Studio for MySQL v9.1
    • What's New in Studio for MySQL v9.0
    • What's New in Studio for MySQL v8.2
    • What's New in Studio for MySQL v8.1
    • What's New in Studio for MySQL v8.0
    • What's New in Studio for MySQL v7.4
    • What's New in Studio for MySQL v7.3
    • What's New in Studio for MySQL v7.2
    • What's New in Studio for MySQL v7.1
    • What's New in Studio for MySQL v7.0
    • What's New in Studio for MySQL v6.3
    • What's New in Studio for MySQL v6.2
    • What's New in Studio for MySQL v6.1
    • What's New in Studio for MySQL v6.0
    • What's New in Studio for MySQL v5.0
    • What's New in Studio for MySQL v4.5
    • What's New in Studio for MySQL v3.6
    • What's New in Studio for MySQL v3.5
    • What's New in Studio for MySQL v3.10
    • What's New in Studio for MySQL v3.0
    • What's New in MyDeveloper Studio v2.1
    • What's New in MyDeveloper Studio v2.0
    • What's New in MyDeveloper Studio v1.51
    • What's New in MyDeveloper Studio v1.5
Devart
© 1997 - 2025 Devart. All rights reserved.