The SQL editor can be opened from the Section 4.3, “The MySQL Toolbar”, or by selecting the , , menu item from the Visual Studio main menu. This displays the New File dialog:
From the New File dialog, select the MySQL template, and then double-click the MySQL Script document, or click the 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 dialog that is displayed. You can enter the server name, user ID, password and database to connect to, or click the button to select other connection string options. Click the button to connect to the MySQL server. To execute your SQL code against the server, click the button on the toolbar.button in the MySQL SQL Editor toolbar. You can enter the connection details into the
The results from any queries are displayed on the Results tab. Any errors are displayed on the Messages tab.