How to create table using sqlite database in android?

Question

public class MyAct extends Activity {
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);

        SQLiteDatabase db = openOrCreateDatabase("MyDb",MODE_PRIVATE,null);
        db.execSQL("CREATE TABLE IF NOT EXISTS MyTab (Month INT(2),Date INT(2),Year INT(4),Event VARCHAR;");
        db.execSQL("INSERT INTO MyTab VALUES (0,1,2012,'mini_proj');");
        db.close();

    }
}

I have written this small snippet to create a table, but it's not working. What is the problem with this code?

@nandeesh no...in ddms it is not showing the name of database table — user1906481
– user1906481, Commented Dec 15, 2012 at 15:31

Lukas Knuth · Accepted Answer · 2012-12-15 15:35:42Z

2

In your first query, you are missing a closing brace:

CREATE TABLE IF NOT EXISTS MyTab (
    Month INT(2),
    Date INT(2),
    Year INT(4),
    Event VARCHAR;

It should be:

CREATE TABLE IF NOT EXISTS MyTab (
    Month INT(2),
    Date INT(2),
    Year INT(4),
    Event VARCHAR
)

Also, note that the query doesn't need to end with a ;, as mentioned in the docs:

Parameters
sql the SQL statement to be executed. Multiple statements separated by semicolons are not supported.

Also, you should ALWAYS check your LogCat output, since this should throw a SQLiteException.

Some further SQLite notes:

SQLite doesn't have a VARCHAR-type. It only has TEXT and will convert any text-like type into it.
Note that giving a length for a datatype is also ignored by SQLite:

SQLite does not impose any length restrictions (other than the large global SQLITE_MAX_LENGTH limit) on the length of strings, BLOBs or numeric values.

answered Dec 15, 2012 at 15:35

Lukas Knuth

25.8k16 gold badges88 silver badges114 bronze badges

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

4 Comments

user1906481 Over a year ago

I modified my code.but still its not reflecting in ddms.now what does that mean?

Lukas Knuth Over a year ago

Read your LogCat output. Also, Datbase things should go into a SQliteDatabaseHelper.

user1906481 Over a year ago

Thanks for your replies.Ya...i have included SQLiteDatabaseHelper.

user1906481 Over a year ago

Actually i am using a date picker.i want to compare date selected in date picker with the date stored in database table,and display the event on that day.Whether my approach is right?please suggest me..

Collectives™ on Stack Overflow

How to create table using sqlite database in android?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related