Error on inserting sequential number in MySQL

Question

I have to insert sequential number from 1 to N in an empty column in a database. Android Studio is giving me the following error when I run my code:

Caused by: android.database.sqlite.SQLiteException: unrecognized token: ":" (code 1): , while compiling: SELECT @i:=0; UPDATE table_name SET column_one = @i:=@i+1;

My line of code:

    db.execSQL("SELECT @i:=0; UPDATE table_name SET column_one = @i:=@i+1;");

(Please note when I change MySQL statement between parenthesis the code runs and gets executed)

Source of SQL code:

Insert sequential number in MySQL

I'm new in Java, Android Studio and MySQL.

What am I missing here?

Help me to understand why MySQL @i:=@i+1 expression is not running properly in Android Studio.

Thanks in advance.

Because android doesn't have mysql from a box, there is SqLite — Beloo
– Beloo, Commented Oct 21, 2016 at 10:32

Luo Ming · Accepted Answer · 2016-10-21 09:58:34Z

0

Because android database is using sqlite，but sqlite dose not supported “@”，if you want batch processing ，I suggest you use Java

answered Oct 21, 2016 at 9:58

Luo Ming

161 bronze badge

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

3 Comments

Dan Over a year ago

Do you mean to create, save and maintain database purely on Java within Android platform? And any suggestion where to start?

Luo Ming Over a year ago

Try this mobilesiri.com/…

Dan Over a year ago

Thanks for help, hope I can put website info together and come up with a solution.

Dharmishtha · Accepted Answer · 2016-10-21 09:54:17Z

0

Try this .

database.execSQL("SELECT " + @i + " :=0   ;  UPDATE table_name SET column_one = " +  @i + " := " + @i "+1;");

answered Oct 21, 2016 at 9:54

Dharmishtha

1,34310 silver badges21 bronze badges

1 Comment

Dan Over a year ago

Both @i outside of parenthesis are now giving me an error before even running the code

Collectives™ on Stack Overflow

Error on inserting sequential number in MySQL

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related