O'Reilly logo

Mastering PhoneGap Mobile Application Development by Kerri Shotts

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 tables

Web SQL Database, as the name implies, relies upon SQL to create tables, store data, and retrieve that data. This means that you essentially need to know an additional language in order to use Web SQL Database; JavaScript isn't sufficient. That said, SQL is pretty easy to grasp. Even so, it's beyond the scope of this chapter to give you a complete understanding of the language. For SQLite's variant of SQL, http://www.sqlite.org/lang.html is a good resource.

Note

The snippets in this section are located at snippets/08/ex3-create-table/ in the code package of this book. When using the interactive snippet playground, select 8: Web SQL Database and Example 3.

Creating a table is fairly straightforward. First, let's look at the SQL syntax ...

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