[sqlite] Syntax Error Loading Values Into Table

[Rich Shepard]

  I have a table created as:

CREATE TABLE hedge (hedge_id integer primary key, hedge_name text);

  Within the sqlite3 shell I try to load values from the file,
'load-hedges.sql,' and the file has 16 lines of the form:

insert into hedge (hedge_name) values ('around');

  SQLite complains, "load_hedges.sql line 1: expected 2 columns of data but 
found
1" Now, I understand that if the first column is type 'integer' and
identified as 'primary key', sqlite will automagically increment that number
if it's not supplied in the insert statement.

  What did I miss here, please?

Thanks,

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]
-----------------------------------------------------------------------------