On Fri, Feb 28, 2014 at 8:00 AM, Dominique Devienne wrote:
> Ran into this [datatype mismatch] error, which surprised me since I
> thought SQLite's
> dynamic typing allowed any value type to be stored in any column.
>
The exception to that rule is an INTEGER PRIMARY KEY
Ran into this error, which surprised me since I thought SQLite's
dynamic typing allowed any value type to be stored in any column.
Either the PK or the FK seem to have some influence (with pragma
foreign_keys on or off), which I didn't expect, since the entered FK
value does match the parent row's
SQLite Database" <sqlite-users@sqlite.org>
> >Subject: Re: [sqlite] Error: datatype mismatch
> >Message-ID: <e490d863a81fdc4cbf3bf970f3c0b...@mail.dessus.com>
> >Content-Type: text/plain; charset="us-ascii"
> >
> >
> >sqlite> CREA
t;From: "Keith Medcalf" <kmedc...@dessus.com>
>To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
>Subject: Re: [sqlite] Error: datatype mismatch
>Message-ID: <e490d863a81fdc4cbf3bf970f3c0b...@mail.dessus.com>
>Content-Type: text/plain;
6 July, 2012 01:30
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Error: datatype mismatch
>
> the table is:
> CREATE TABLE webinfo (inx INTEGER PRIMARY KEY ,website varchar(50)
> UNIQUE,userna
> me varchar(50),password varchar(50));
>
> and the txt file kk.txt is utf8:
On Mon, Jul 16, 2012 at 3:30 AM, YAN HONG YE wrote:
> the table is:
> CREATE TABLE webinfo (inx INTEGER PRIMARY KEY ,website varchar(50)
> UNIQUE,userna
> me varchar(50),password varchar(50));
>
> and the txt file kk.txt is utf8:
> 0,nytime,gf,a1..7
> 1,bbc,1982,tbth432
>
the table is:
CREATE TABLE webinfo (inx INTEGER PRIMARY KEY ,website varchar(50) UNIQUE,userna
me varchar(50),password varchar(50));
and the txt file kk.txt is utf8:
0,nytime,gf,a1..7
1,bbc,1982,tbth432
2,oknic,y...@sohu.com,bbaa1122
when I use
" .import kk.txt webinfo"
in cmd line I got the
7 matches
Mail list logo