Creating and populating a database table

With the database console application active, you can open it in your web browser and use it to manipulate the MySQL service. We'll use the console application to create a database table and populate it. The table will implement a very simple to-do list.

Our database table will be called "Tasks" and will have three columns:

• ID: It is an automatically incrementing number that uniquely identifies the row

• Name: It is a string value containing the name of a task to be done

• Completed: It is a Boolean value containing the completion status of the task.

Now, perform the following steps:

1. Point your web browser to the home page for the database console. If you didn't note the address when you created it, go to the application control panel and click on Visit Live Site.

2. An authentication dialog appears. The user name is the same e-mail address you use to access your AppFog account. The password is the value you previously set in the PMA_PASSWORD environment variable...