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 SQL statements terminated with a ";"
sqlite>
however, no database is created. What am I doing wrong and what
do I need to do to create an empty database 'test.db'?
Thanks,
LA
read http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html
for instruction how to use the CLI (sqlite3.exe or the Linux binary)
Oliver
Thanks for your reply. As it turns out, that's the very tutorial I used
to run my test case. The tutorial shows:
$ sqlite3 test.db
SQLite version 3.0.8
Enter ".help" for instructions
sqlite> .quit
and I did:
->sqlite3 test.db
SQLite version 3.7.13 2012-06-11 02:05:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .q
but did not get an empty file.
As an OP pointed out, I needed 'sqlite3 test.db ""'
I think this thread can now safely die--thanks all.
Regards,
LA
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
