from file with 3 colums to table
with 4 columns
Just because I was bored ;) I decided to take a stab at this one as well
(following Simon's excellent guidance).
I had thought because of what it says in the FAQ here:
http://sqlite.org/faq.html#q1
that it should be possible to im
On 9 July 2010 06:18, wrote:
>
>
> Thank you very much Simon.
>
> That worked very slick.
>
>
>
> Say, is there a way to put all of the SQLite3 commands I used into a script
> and have SQLite3 execute them in the script sequentially?
>
Yes, several ways:
use .read command (sqlite3 tst.db ".re
ssion of SQLite Database"
Sent: Thursday, July 8, 2010 4:48:20 PM
Subject: Re: [sqlite] importing data from file with 3 colums to table with
4columns
On 9 July 2010 00:07, wrote:
>
>
> Hello,
>
> I have a db tbl with the following schema:
>
>
&
On 9 July 2010 00:07, 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.
>
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
Catf
5 matches
Mail list logo