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 column, which is only
allo
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
code file to my database?
>
Your easiest solution would be to run your script on either Mac or Linux.
>
> >Date: Mon, 16 Jul 2012 02:19:12 -0600
> >From: "Keith Medcalf"
> >To: "General Discussion of SQLite Database"
> >Subject: Re: [sqlite] Err
t;From: "Keith Medcalf"
>To: "General Discussion of SQLite Database"
>Subject: Re: [sqlite] Error: datatype mismatch
>Message-ID:
>Content-Type: text/plain; charset="us-ascii"
>
>
>sqlite> CREATE TABLE webinfo (inx INTEGER PRIMARY KEY ,website v
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
> 2,oknic,y...@sohu.com,bb
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 erro
7 matches
Mail list logo
