near "COLUMN_NAME": syntax error (code 1) in SQLite

Question

I'm Working on Android project and I'm using SQLite database in that, I have written one insert query as :

sqliteDB_Obj.execSQL("INSERT INTO tbl_order_master (user_id, order, amount)" + "VALUES(" + strUserId +","+ strOrderString +","+ dblAmount +");");

But I'm getting following error

android.database.sqlite.SQLiteException: near "order": syntax error (code 1): , while compiling: INSERT INTO tbl_order_master (user_id, order, amount) VALUES(dny, my test order, 160.0);

some people have asked same question before so according to the answer mentioned their I have tried following way :

String strTableName="tbl_order_master";
String strQuery= String.format("INSERT INTO %s (user_id, order, amount) VALUES(%s, %s, %s);", strTableName, strUserId, strOrderString, ""+dblAmount);
sqliteDB_Obj.execSQL(strQuery);

but still getting same error Please help.. Thanks..!

probably the problem is that the order name is a reserved word? try using sort_order or similar as column name or write it with backticks. — Olli
– Olli, Commented Jun 12, 2014 at 12:07
possible duplicate of Syntax error due to using a reserved word as a table or column name in MySQL — vhu
– vhu, Commented Jun 12, 2014 at 12:11

laalto · Accepted Answer · 2014-06-12 12:09:36Z

3

If you use a reserved name such as order as an identifier, put it in "double quotes". Or just rename the identifier so it isn't a reserved keyword.

Also in SQL, string literals need to be written in 'single quotes'. Yours are not quoted.

It's better to use parameters instead though, e.g.

execSQL("INSERT INTO tbl_order_master (\"user_id\", \"order\", \"amount\") VALUES (?, ?, ?)",
    new String[] { strUserId, strOrderString, Double.toString(dblAmount) } );

passing the parameter values in the second arg.

answered Jun 12, 2014 at 12:09

laalto

153k68 gold badges293 silver badges306 bronze badges

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

Comments

Gabber · Accepted Answer · 2014-06-12 12:15:52Z

1

try this

 sqliteDB_Obj.execSQL("INSERT INTO tbl_order_master (`user_id`, `order`, `amount`)" + "VALUES('" + strUserId +"','"+ strOrderString +"',"+ dblAmount +");");

change the column name "order" or using `order`

edited Jun 12, 2014 at 12:15

answered Jun 12, 2014 at 12:10

Gabber

7,2593 gold badges35 silver badges47 bronze badges

Comments

MilapTank · Accepted Answer · 2014-06-12 12:10:23Z

0

ORDER is reserved word in SQL so you can not use as field name

sqliteDB_Obj.execSQL("INSERT INTO tbl_order_master (user_id, order, amount)" + "VALUES(" + strUserId +","+ strOrderString +","+ dblAmount +");");

change to

sqliteDB_Obj.execSQL("INSERT INTO tbl_order_master (user_id, s_order, amount)" + "VALUES(" + strUserId +","+ strOrderString +","+ dblAmount +");");

answered Jun 12, 2014 at 12:10

MilapTank

10.1k7 gold badges40 silver badges55 bronze badges

Comments

Giru Bhai · Accepted Answer · 2014-06-12 12:11:34Z

0

Try changing the name of your order column to something else. order is a reserved word in sqlite (i.e. order by).And Also single quotes are missing

So try this (Change order like m_order)

sqliteDB_Obj.execSQL("INSERT INTO tbl_order_master (user_id, m_order, amount)" + "VALUES('" + strUserId +"','"+ strOrderString +"','"+ dblAmount +"')");

answered Jun 12, 2014 at 12:11

Giru Bhai

14.4k5 gold badges50 silver badges74 bronze badges

Comments

ngrashia · Accepted Answer · 2014-06-12 12:15:03Z

0

Try this. As a good practice, always use quotes to wrap string field values.

sqliteDB_Obj.execSQL("INSERT INTO tbl_order_master (user_id, order, amount) " + " VALUES ( '"    + strUserId +"', '"+ strOrderString +"',"+ dblAmount +") ");

answered Jun 12, 2014 at 12:15

ngrashia

9,8945 gold badges45 silver badges58 bronze badges

Collectives™ on Stack Overflow

near "COLUMN_NAME": syntax error (code 1) in SQLite

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related