sqlite3 update table

You have two options. First,you could simply add a new column with the following:

ALTER TABLE {tableName} ADD COLUMN COLNew {type};

Second,and more complicatedly,but would actually put the column where you want it,would be to rename the table:

TABLE {tableName} RENAME TO TempOldTable;

Then create the new table with the missing column:

CREATE TABLE {tableName} (name TEXT, COLNew {type} DEFAULT {defaultValue}, qty INTEGER, rate REAL);

And populate it with the old data:

INSERT INTO {tableName} (name, qty, rate) SELECT name, rate FROM TempOldTable;

Then delete the old table:

DROP TABLE TempOldTable;

I'd much prefer the second option,as it will allow you to completely rename everything if need be.

http://stackoverflow.com/questions/4253804/insert-new-column-into-table-in-sqlite

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!