Re: [sqlite] About Alter table add column

Hi, If you are specifing fieldnames in your statements then there won't be any problem. Means if a statement like INSERT INTO Person (ID, name , addr ) VALUES ( 10,'Yoky','India'); will not be distrubed. But if your other code contains INSERT INTO Person VALUES ( 10,'Yoky','India'); then you will

[sqlite] About Alter table add column

Hi all, I have a question about alter table. for example, I create a table person(ID integer primary key, name text, addr text), Then I want to upgrade the table and add some columns, "alter table person add age integer", I want to know the changed table structure will have a big effect on the