android指定sqlite路径_Sqlite将列添加到表中的特定位置（Android）

This is the code that works for adding a column.

mDb.execSQL("ALTER TABLE " + table_name +

" ADD COLUMN " + column_name + " text");

My problem the column is created at the last position of the table.

Column1|Column2|Column3|Column4|Column5|NewAddedColumn6

E.g. Is is possible to add a column between Column3 and Column4???

Column1|Column2|Column3|NewAddedColumn6|Column4|Column5

解决方案

As per documentation

The ADD COLUMN syntax is used to add a new column to an existing

table. The new column is always appended to the end of the list of

existing columns.

Hence, answer to your question is NO

But, there is a work around way.

Read this answer on SO.