On 9 July 2010 00:07,  <c...@comcast.net> wrote:
>
>
> Hello,
>
> I have a db tbl with the following schema:
>
>
>
> _ID integer primary key autoincrement
>
> name varchar(40)
>
> category varchar(40)
>
> recommendation varchar(40)
>
>
>
> I have a data file I want to import which contains 3 columns worth of data.
>
> It looks like this:
>
>
>
> Barracuda|seafood|No
> Catfish|seafood|No
> Caviar|seafood|No
> Conch|seafood|No
> Herring(pickled)|seafood|No
> Lox(smoked salmon)|seafood|No
> Octopus|seafood|No
>
>
>
> When I try and import it I get the following error:
>
> "line 1: expected 4 columns of data but found 3"
>
>
>
> Since I obviously don't want to explicitly load data into the _ID column, how 
> do I tell it to put the data from the import file into the 3 remaining 
> columns?
>

Create a table (tmp) with three cols to receive the data from your
file, then use
INSERT INTO tbl( name, category, recommendation ) SELECT * from tmp;

>
>
> Thank you in advance.
>
> -Chris
>

Regards,
Simon
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to