On Wed, 20 Sep 2006, Martin Jenkins wrote:
I've never used -init but a CLI session to create a table is simply:
Martin,
I _am_ using the CLI; that's what the Command Line Processor (CLP) is
for.
C:\>sqlite3 test Loading resources from C:\Documents
and Settings\Martin/.sqliterc
SQLite version 3.3.6
Enter ".help" for instructions
sqlite> create table t1(id INTEGER PRIMARY KEY, val TEXT);
sqlite> insert into t1(val) values ("Hello");
sqlite> insert into t1(val) values ("Hello");
Yes, you first create the database by name, then add each table
interactively. I have the entire schema in a single file and prefer to not
enter 254 lines individually again from within the interactive system.
Further investigation reveals that the correct approach is to use
indirection; specifically:
[EMAIL PROTECTED] /data1/eikos]$ sqlite3 testing.db < feia.sql
This reads the DDL from the file, feia.sql, and feeds it to the
testing.db.
Rich
--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc.(TM) | Accelerator
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
