Am 02.03.2012 11:03, schrieb Oliver Peters:
sorry I meant
CREATE TABLE test(
a TEXT PRIMARY KEY
);
(without INTEGER, usually I write INTEGER and not TEXT :-) )
Am 02.03.2012 10:44, schrieb Christoph P.U. Kukulies:
When defining a column TEXT PRIMARY KEY (is that possible on TEXT?),
yes
would this imply uniqueness?
yes
Or would I have to write something like TEXT PRIMARY KEY UNIQUE ?
no and that doesn't make sense I'd say
[...]
simply try (untested)
CREATE TABLE test(
a TEXT INTEGER PRIMARY KEY
);
INSERT INTO test(a) VALUES('1');
INSERT INTO test(a) VALUES('1');
oliver
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
