The MySQL SQL Editor can be opened from the MySQL toolbar or by clicking , , and from the Visual Studio main menu. This action displays the New File dialog.
From the New File dialog, select the MySQL template, select the MySQL Script document, and then click .
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 queries are displayed in the Results tab and relevant information appears in the MySQL Output pane. The previous example displays the query results within a Result Grid. You can also select the Field Types, Execution Plan, and Query Stats for an executed query.