-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ted Rolle wrote: > How do I let this start out at the default value and auto increment? > My column separator is '|'.
Create a temporary table and import into that. Then copy those values into your permanent table using something like: insert into perm_table select null,* from temp_table; Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkrrO90ACgkQmOOfHg372QRNgQCgq/obmjL/Rw862bsqk9GIU4FE yQYAoLc3JEugW75ZSGPZADTuZNC5Ruww =CZTr -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users