I guess you didn't work with SQL anywhere in your developer life, right? Read some books or internet pages about it. You can start from here http://en.wikipedia.org/wiki/SQL and follow any links there.
To update column in all rows of the table you need to issue the following statement: UPDATE table_name SET column_name = value It doesn't require you to loop through all rows although DBMS will iterate all of them for you. Pavel On Thu, Oct 15, 2009 at 11:22 AM, Kavita Raghunathan <[email protected]> wrote: > Thanks Pavel and Owen. This is very useful information. > > Also how can we change a whole column at a time ? > In otherwords, the entire column needing to be changed would > involve looping through each entry and changing that value, > instead i want to substitute a whole column. > > Thanks! > Kavita > ----- Original Message ----- > From: "Owen O'Neill" <[email protected]> > To: "General Discussion of SQLite Database" <[email protected]> > Sent: Thursday, October 15, 2009 9:59:32 AM GMT -06:00 US/Canada Central > Subject: Re: [sqlite] Replacing a table > > > Run the sql > 'delete from "tablename";' > > if the table definition is different (different column names or data > types ) then you will need to drop the table and create a new one. > 'drop table "tablename";' > > http://www.sqlite.org/lang_createtable.html > > if the table is huge you might get different performance depending on > whether your journal settings are to truncate or delete or pad etc. > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Kavita Raghunathan > Sent: Thursday, October 15, 2009 3:51 PM > To: General Discussion of SQLite Database > Cc: Kelvin Xu > Subject: [sqlite] Replacing a table > > Hi, > > Is there a way to use the sqlite wrappers to "replace" or delete a table > completely ? > (without looping through and deleting each row and column) > The number of columns and rows of the new table is identical to the > number > of columns and rows of the old table being replaced. Is there a quick > way > to do that? > > Thanks, > Kavita > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
