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

Figure 4.19. Getting Started Tutorial - Edit Table Data

In the wizard, select the “Big Iron Server” connection from the stored connection list. 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 need not enter values directly for this column. In the data grid, enter the movie information shown in the following table.

Now click the Apply 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 to apply these changes to the live server.

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

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

Figure 4.20. 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 window 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 list. 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 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 4.21. Getting Started Tutorial - Results