sqlite sql syntax error near '('

Question

sqlite sql syntax error near '('

<code>
    @Override
    public void onCreate(SQLiteDatabase arg0) {
    StringBuilder sb = new StringBuilder();
    sb.append("create table IF NOT EXISTS " + tableName + "(" );
    sb.append(" eng TEXT primary key,");
    sb.append(" gra TEXT not null,");
    sb.append(" memo TEXT null,");
    sb.append(" fsen TEXT null,");
    sb.append(" ox INTEGER not null DEFAULT 0,");
    sb.append(" oxSeq TEXT null,");
    sb.append(" timeCreate TEXT not null DEFAULT datetime('now', 'localtime'),");
    sb.append(" timeLast TEXT not null DEFAULT datetime('now', 'localtime') )");
    arg0.execSQL(sb.toString());
    Log.w(" -- Result -- ", tableName + " is created.");
    }

    ////Error message is like following...

    android.database.sqlite.SQLiteException: near "(": 
    syntax error (code 1): , while compiling: 
    create table IF NOT EXISTS userDic( 
    eng TEXT primary key, 
    kor TEXT not null, 
    memo TEXT null, 
    fsen TEXT null, 
    ox INTEGER not null DEFAULT 0, 
    oxSeq TEXT null, 
    timeCreate TEXT not null DEFAULT datetime('now', 'localtime'), 
    timeLast TEXT not null DEFAULT datetime('now', 'localtime') ) 
</code>

I don't know why the error is occurred... I don't know why the error is occurred... I don't know why the error is occurred... I don't know why the error is occurred... I don't know why the error is occurred... I don't know why the error is occurred...

laalto · Accepted Answer · 2015-12-07 18:56:58Z

2

To use a default value, replace datetime('now', 'localtime') with e.g. CURRENT_TIMESTAMP. Note that it won't be localtime but UTC zulu time.

To use an expression as a default, it needs to be in () parentheses, e.g. DEFAULT(datetime('now', 'localtime')).

https://www.sqlite.org/lang_createtable.html

edited Dec 7, 2015 at 18:56

answered Dec 7, 2015 at 17:49

laalto

153k68 gold badges293 silver badges306 bronze badges

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

1 Comment

김도형 Over a year ago

I see... so... I need to change the part "DEFAULT datetime('now', 'localtime')" as CURRENT_TIMESTAMP...

rohit89 · Accepted Answer · 2015-12-07 20:07:15Z

0

Actually, I found the answer with others' idea.

Problem is DEFAULT

I need to change the part

DEFAULT datetime('now', 'localtime')

to

DEFAULT(datetime('now', 'localtime'))

() is needed. Now it's working.

edited Dec 7, 2015 at 20:07

rohit89

5,7833 gold badges28 silver badges42 bronze badges

answered Dec 7, 2015 at 18:36

김도형

316 bronze badges

Comments

Blundell · Accepted Answer · 2015-12-07 17:48:56Z

-1

tableName needs to be surrounded in single quotes:

corrected:

 sb.append("create table IF NOT EXISTS '" + tableName + "' (" );

answered Dec 7, 2015 at 17:48

Blundell

76.8k33 gold badges222 silver badges242 bronze badges

2 Comments

Blundell Over a year ago

@FrankN.Stein oh am I wrong? Just went and looked it up in my project and am using single quotes around the table name, then again i am not using .execSQL

Phantômaxx Over a year ago

Try removing them, it will work as well (if the table name is a single word). OR maybe your table name contains spaces (but I use [ and ] in that case).

Collectives™ on Stack Overflow

sqlite sql syntax error near '('

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related