Re: [sqlite] how to add a new column quickly

> To: <sqlite-users@sqlite.org> Sent: Saturday, May 05, 2007 8:09 PM Subject: Re: [sqlite] how to add a new column quickly > On Sat, May 05, 2007 at 19:30:59 +0800, ronggui wong wrote: >> Thanks. But there is no typo, what I want is a general solution. >> >> 2007/5/5, To

Re: [sqlite] how to add a new column quickly

Thanks. But there is no typo, what I want is a general solution. 2007/5/5, Tomash Brechko <[EMAIL PROTECTED]>: On Sat, May 05, 2007 at 14:01:56 +0800, ronggui wong wrote: > . update tablename set newcolname=1 where ROWID=1 > . update tablename set newcolname=2 where ROWID=2 > . u

[sqlite] how to add a new column quickly

I would like to add a new column to an existing table. I use .alter table tablename add newcolname to add a new col, and use . update tablename set newcolname=1 where ROWID=1 . update tablename set newcolname=2 where ROWID=2 . update tablename set newcolname=2 where ROWID=3 . My question is:

Re: [sqlite] can ignore n lines when .import data file?

2006/1/7, Griggs, Donald <[EMAIL PROTECTED]>: > > Regarding: > > I want to use .import ... but the first line is the variable(fields), so I > want to ignore it. > = > > Possible option #1: > > If it wouldn't violate any database-enforced constraints, why not import

Re: [sqlite] can ignore n lines when .import data file?

does not use \t,I have to use sed(or other tools) to change Tab to |. so My puzzle is why SQLite not support \t? > On 1/6/06, ronggui wong <[EMAIL PROTECTED]> wrote: > > I want to use .import to import a data file into SQLite.but the first > > line is the variable(fields),so I

Re: [sqlite] can ignore n lines when .import data file?

2006/1/7, Griggs, Donald <[EMAIL PROTECTED]>: > > Regarding: > > I want to use .import ... but the first line is the variable(fields), so I > want to ignore it. > = > > Possible option #1: > > If it wouldn't violate any database-enforced constraints, why not import

[sqlite] can ignore n lines when .import data file?

I want to use .import to import a data file into SQLite.but the first line is the variable(fields),so I want to ignore it.delete the first row of the data is one solution,But the data file is large ,and try to use sed to delete the first row,it takes long time a|b|c 1|2|3 |3|1 ...

Re: [sqlite] how can I import CSV file into SQLite quickly

sorry ,maked an mistake. actually,the data size is 805 vars, 118519 obs. 2006/1/5, ronggui wong <[EMAIL PROTECTED]>: > Thanks to all give response to help. > This is my solution using the luanguage I familiar.(http://www.r-project.org). > > I use the code to read a 11819x807 csv

Re: [sqlite] how can I import CSV file into SQLite quickly

Thanks to all give response to help. This is my solution using the luanguage I familiar.(http://www.r-project.org). I use the code to read a 11819x807 csv file and it takes 10 minus.I think is not too slow .(My PC:1.7G,512M RAM) #code begins rm(list=ls()) f<-file("D:\\wvsevs_sb_v4.csv","r")#134M

[sqlite] how can I import CSV file into SQLite quickly

I have a very large CSV file with 1 rows and 100 columns.and the file looks like the following: "a","b","c","d", "1","2","1","3" , "3","2","2","1", .. If I use .import,It seems I have to set the variable names manually . Is there any way to import the whole data file into SQLite quickly?