Re: [sqlite] Can't create empty database

2012-06-25 Thread Valentin Davydov
On Mon, Jun 25, 2012 at 01:01:46AM -0700, L Anderson wrote: > Googling on how to create a sqlite database (empty one) it appears > I need only do 'sqlite3 test.db'. However, when I try that I get: > > ->sqlite3 test.db > SQLite version 3.7.13 2012-06-11 02:05:22 > Enter ".help" for instructions >

Re: [sqlite] Can't create empty database

2012-06-25 Thread Niall O'Reilly
On 25 Jun 2012, at 12:48, Black, Michael (IS) wrote: > Well...it doesnt' any more on Windows and Linux at least as of 3.7.9 > > The file doesn't get created until you execute at least one command relevant > to it. > > So do a .schema or .dump or such and it creates the empty file. > > Or just

Re: [sqlite] Can't create empty database

2012-06-25 Thread Black, Michael (IS)
qlite.org] on behalf of Niall O'Reilly [niall.orei...@ucd.ie] Sent: Monday, June 25, 2012 6:26 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Can't create empty database On 25 Jun 2012, at 11:06, L Anderson wrote: > So then on page 'http://www.sqlite.org

Re: [sqlite] Can't create empty database

2012-06-25 Thread Niall O'Reilly
On 25 Jun 2012, at 11:06, L Anderson wrote: > So then on page 'http://www.sqlite.org/quickstart.html' > under 'Create A New Database', the first bullet: > > 'At a shell or DOS prompt, enter: "sqlite3 test.db". This will create a new > database named "test.db". (You can use a different name if y

Re: [sqlite] Can't create empty database

2012-06-25 Thread L Anderson
Oliver Peters wrote: Am 25.06.2012 10:01, schrieb L Anderson: Googling on how to create a sqlite database (empty one) it appears I need only do 'sqlite3 test.db'. However, when I try that I get: ->sqlite3 test.db SQLite version 3.7.13 2012-06-11 02:05:22 Enter ".help" for instructions Enter SQ

Re: [sqlite] Can't create empty database

2012-06-25 Thread L Anderson
Patrik Nilsson wrote: sqlite3 test.db "" It creates an empty file, zero bytes long. Thanks for your quick reply. So then on page 'http://www.sqlite.org/quickstart.html' under 'Create A New Database', the first bullet: 'At a shell or DOS prompt, enter: "sqlite3 test.db". This will create a

Re: [sqlite] Can't create empty database

2012-06-25 Thread Oliver Peters
Am 25.06.2012 10:01, schrieb L Anderson: Googling on how to create a sqlite database (empty one) it appears I need only do 'sqlite3 test.db'. However, when I try that I get: ->sqlite3 test.db SQLite version 3.7.13 2012-06-11 02:05:22 Enter ".help" for instructions Enter SQL statements terminate

Re: [sqlite] Can't create empty database

2012-06-25 Thread Patrik Nilsson
sqlite3 test.db "" It creates an empty file, zero bytes long. On 06/25/2012 10:01 AM, L Anderson wrote: > Googling on how to create a sqlite database (empty one) it appears > I need only do 'sqlite3 test.db'. However, when I try that I get: > > ->sqlite3 test.db > SQLite version 3.7.13 2012-06-