O'Reilly logo

Implementing AppFog by Isaac Rabinovitch, Matthew Nohr

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required