On the Home screen click the link Edit Table Data in the SQL Development area of the Workspace. This launches Edit Table Data wizard.

Figure 16.18. Getting Started Tutorial - Edit Table Data

In the wizard select the “Big Iron Server” connection from the stored connection drop down listbox. Click Next.

Select the schema, dvd_collection. Select the table to edit, movies. Click Finish.

You will see a data grid. This is where you can enter the data for your database. Remember that the movie_id was set to be autoincrement, so you do not need to enter values directly for this column. In the data grid enter the following movie information:

Note: do not modify any values in the movie_id column.

Now click the Apply changes to data source button in the toolbar located in the bottom right corner. A list of SQL statements will be displayed. Confirm that you understand the operations to be carried out. Click Apply SQL to apply these changes to the live server.

Confirm that the script was executed correctly and then click Finish.

View the data grid again and observe that the autoincrement values have been generated.

Figure 16.19. Getting Started Tutorial - Edit Data

Now you will check that the data really has been applied to the live server. Launch the MySQL Command Line Client. Enter SELECT * FROM movies; to see the data just entered.

You can also carry out a similar check from within MySQL Workbench. Click on the Home screen tab.

Click the link Open Connection to start Querying in the SQL Development section of the Workspace. This will launch the Connect to Database dialog. Select “Big Iron Server” from the drop down listbox. Click OK.

A new SQL Editor tab will be displayed. In the SQL Statements area enter the following code:

USE dvd_collection;
SELECT * FROM movies;

Now click the Execute SQL Script in Connected Server toolbar button. This resembles a small lightning bolt. The SQL Editor will display a new Result tab contain the result of executing the SQL statements.

Figure 16.20. Getting Started Tutorial - Results