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
new database named "test.db". (You can use a different name if you like.)'
is not strictly correct.
I guess I was expecting 'sqlite3 test.db' or even 'sqlite3 test.db ""'
to have created an "empty database" that contained the 100 byte 'SQLite
format 3' database header structure together with any internal tables
such as 'sqlite_master' and not just an empty file.
Regards,
LA
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-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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
