version 3.7.9 2011-11-01 00:52:41 KUbuntu 12.04 LTS 32-bit ex1.sql
CREATE TABLE table_ex1( Groupid INTEGER PRIMARY KEY, GroupName TEXT ); .separator '|' .import ex1.csv table_ex1 .quit ex1.csv 1|NONE 2|TWO 3|THREE 4|FOUR 5|FIVE sqlite> .read ex1.sql Error: datatype mismatch sqlite> .quit ex2.sql CREATE TABLE table_ex1( Groupid INT PRIMARY KEY, GroupName TEXT ); .separator '|' .import ex1.csv table_ex1 .quit sqlite> drop table table_ex1; sqlite> .read ex2.sql sqlite> .quit Makes absolutely no sense. INT and INTEGER should be exactly the same. For this limited set of data both should have worked. Roland Hughes, President Logikal Solutions (630)-205-1593 - cell http://www.theminimumyouneedtoknow.com http://www.infiniteexposure.net _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users