subject:"\[sqlite\] sqlite command shell \- read\/process file then exit\?"

Re: [sqlite] sqlite command shell - read/process file then exit?

2011-11-22 Thread Kees Nuyt

On Mon, 21 Nov 2011 14:01:47 +, Simon Davies wrote: >On 21 November 2011 13:41, SupportLists wrote: >> Hi, >> >> I am trying to use sqlite3 command shell with -init filename. >> >> The file has: >> >> CREATE TABLE griddata (id_suit

Re: [sqlite] sqlite command shell - read/process file then exit?

2011-11-21 Thread Simon Davies

On 21 November 2011 13:41, SupportLists wrote: > Hi, > > I am trying to use sqlite3 command shell with -init filename. > > The file has: > > CREATE TABLE griddata (id_suit VARCHAR(14) PRIMARY KEY,xpos DECIMAL(7),ypos > DECIMAL(7),cellvalue DECIMAL(14,5) DEFAULT -); >

[sqlite] sqlite command shell - read/process file then exit?

2011-11-21 Thread SupportLists

Hi, I am trying to use sqlite3 command shell with -init filename. The file has: CREATE TABLE griddata (id_suit VARCHAR(14) PRIMARY KEY,xpos DECIMAL(7),ypos DECIMAL(7),cellvalue DECIMAL(14,5) DEFAULT -); .separator "," .import /home/cquiros/temp/layers/layers/New/lgp001.csv griddata ALTER