MySQL and Windows  /  ...  /  New in Version 2.0

6.1.1 New in Version 2.0

This section summarizes many of the new features added to the 2.0 release series in relation to the MySQL for Visual Studio 1.2 release series. MySQL for Visual Studio 2.0.5 is a development release.

New features are described in the following sections:

For notes detailing the changes in each point release, see the MySQL for Visual Studio Release Notes.

Viewing MySQL Query Output

An output pane was added to the MySQL SQL, JavaScript, and Python editors to display information about each executed query. The output pane includes the information that previously appeared in the Messages tab.

Figure 6.1 MySQL SQL Editor Output

MySQL Output pane.

Version Support for Visual Studio

Beginning with MySQL for Visual Studio 2.0.5:

  • Support for Microsoft Visual Studio 2017 was added.

  • Support for Microsoft Visual Studio 2010 was removed.

Switching Connections from Script and Code Editors

A drop-down list was added to the toolbar of the SQL, JavaScript, and Python editors from which you can select a valid connection. JavaScript and Python editors show only the connections that support the X Protocol.

Figure 6.2 Switching Connections

Use the drop-down list to select a different connection.

Making a Connection

A new MySQL Connections Manager tool was added, and it can create and manage MySQL connections. It is found under the Server Explorer.

Figure 6.3 Opening the MySQL Connections Manager Dialog

Opening the MySQL Connections Manager Dialog

This button opens the MySQL Connections Manager dialog that enables the sharing of stored MySQL connections with MySQL Workbench, if it is installed. MySQL connections are displayed in a simpler way and can be created and edited from within this dialog. These connections can be imported to the Visual Studio Server Explorer for use with Visual Studio.

After opening the MySQL Connections Manager:

Figure 6.4 MySQL Connections Manager Dialog: Choosing a Connection

MySQL Connections Manager Dialog: Choosing a Connection

To add a new MySQL connection with the MySQL Connections Manager:

Figure 6.5 MySQL Connections Manager Dialog: New Connection

MySQL Connections Manager Dialog: New Connection

MySQL Toolbar

In the Server Explorer, and with MySQL Server 5.7, the MySQL connection context-menu was changed to show the options to create JavaScript or Python scripts, along with the existing SQL script option.

Figure 6.6 MySQL Toolbar: Create New Script

MySQL Toolbar: Create New Script

Select JavaScript or Python to launch the MySQL code editor for the selected language.

MySQL JavaScript and Python Code Editors

Use the code editor to write and execute JavaScript or Python queries with MySQL Server 5.7 and higher, or as before, use SQL queries.

Figure 6.7 MySQL Editor: Script Template

MySQL Editor: Script Template

Select MyJs Script or MyPy Script to launch the MySQL code editor for the selected language.

Figure 6.8 MySQL Editor: JavaScript Code Editor

MySQL Editor: JavaScript Code Editor

Figure 6.9 MySQL Editor: Python Code Editor

MySQL Editor: Python Code Editor