4.15 MySQL SQL Editor

The SQL editor can be opened from the Section 4.3, “The MySQL Toolbar”, or by selecting the File, New, File... menu item from the Visual Studio main menu. This displays the New File dialog:

Figure 4.66 MySQL SQL Editor - New File

MySQL SQL Editor - New File

From the New File dialog, select the MySQL template, and then double-click the MySQL Script document, or click the Open button.

The MySQL SQL Editor will be displayed. You can now enter SQL code as required, or connect to a MySQL server. Click the Connect to MySQL button in the MySQL SQL Editor toolbar. You can enter the connection details into the Connect to MySQL dialog that is displayed. You can enter the server name, user ID, password and database to connect to, or click the Advanced button to select other connection string options. Click the Connect button to connect to the MySQL server. To execute your SQL code against the server, click the Run SQL button on the toolbar.

Figure 4.67 MySQL SQL Editor - Query

MySQL SQL Editor - Query

The results from any queries are displayed on the Results tab. Any errors are displayed on the Messages tab.