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 have to insert the newly added column to those statements.
ALWAYS USE PARAMETRISED SQL STATEMENTS to avoid these type of conditions. Rajesh Nair. On 2/5/09, yoky <yok...@gmail.com> wrote: > > 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 after DB operation (like > Insert, Select....) or not? Suppose the table already > has many many rows. > Thanks! > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Regards Rajesh Nair _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
