Create or open a database table in HTML5

Question

If I use the below code:

var db = openDatabase("CurrADinfo", "1", "A list of QC Points.", 100000);
db.transaction(function (tx) {
     tx.executeSql('CREATE TABLE foo (id , text)');
});

It will create or open the database CurrADinfo if it exists. But the second line will always create a new table.

I want to create a table once and next time when I try to create it should return a flag that it is found in the database. How can I do that?

openDatabase will open the database if it exists, or create a new one if it does not. I'm not sue what you need past that. — MetalFrog
– MetalFrog, Commented Dec 15, 2011 at 14:28
I'm not sure what this question has to do with HTML5. Help me out? — james.garriss
– james.garriss, Commented Oct 3, 2012 at 16:58

j0k · Accepted Answer · 2012-08-23 07:47:23Z

2

If I understand your question (which isn't completely clear to me), you need to create a table if one doesn't already exist:

tx.executeSql('CREATE TABLE IF NOT EXISTS foo (id , text)');

edited Aug 23, 2012 at 7:47

j0k

22.8k28 gold badges81 silver badges90 bronze badges

answered Aug 23, 2012 at 0:48

Cam Collins

611 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create or open a database table in HTML5

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related