Thanks for your responses. Wish you a Happy new year.
I tested with below query to create a table: "create table if not exists durtree (id integer primary key autoincrement, c1 varchar[260], c2 varchar[260], c3 varchar[260], c4 varchar[260], c5 varchar[260], c6 varchar[260], c7 varchar[260], c8 varchar[260], c9 varchar[260], c10 varchar[260], c11 varchar[260], c12 varchar[260], c13 varchar[260], c14 varchar[260], c15 varchar[260], c16 varchar[260], c17 varchar[260], c18 varchar[260], c19 varchar[260], c20 varchar[260], c21 varchar[260], c22 varchar[260], c23 varchar[260], c24 varchar[260], c25 varchar[260], c26 varchar[260], c27 varchar[260], c28 varchar[260], c29 varchar[260], c30 varchar[260], c31 varchar[260], c32 varchar[260], c33 varchar[260], c34 varchar[260], c35 varchar[260], c36 varchar[260], c37 varchar[260], c38 varchar[260], c39 varchar[260], c40 varchar[260], c41 varchar[260], c42 varchar[260] default null, c43 varchar[260] default null, c44 varchar[260] default null, c45 varchar[260] default null, c46 varchar[260] default null, c47 varchar[260] default null, c48 varchar[260] default null, c49 varchar[260] default null, c50 varchar[260] default null, c51 varchar[260] default null, c52 varchar[260] defaul null, c53 varchar[260] default null, c54 varchar[260] defaul null, c55 varchar[260] default null, c56 varchar[260] default null, c57 varchar[260] default null, c58 varchar[260] default null, c59 varchar[260] default null, c60 varchar[260] default null, c61 varchar[260] default null, c62 varchar[260] default null, c63 varchar[260] default null, c64 varchar[260] default null, c65 varchar[260] default null, c66 varchar[260] default null, c67 varchar[260] default null, c68 varchar[260] default null, c69 varchar[260] default null, c70 varchar[260] default null, unique (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51, c52, c53, c54, c55, c56, c57, c58, c59, c60, c61, c62, c63, c64, c65, c66, c67, c68, c69, c70));" I want to make c1 to c70 as unique with default null. But, I could not with above query. I can make c42 to c70 as default null and c1 to c70 as unique. If I add default null to c41 and c40, it gets failed. objective: I am trying to store tree in a sqlite3 db depth of 70. I need high performance when accessing any level of the tree. Thanks in advance, Durga. On Fri, Dec 30, 2011 at 11:17 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 30 Dec 2011, at 4:40pm, Jay A. Kreibich wrote: > > > On Fri, Dec 30, 2011 at 04:10:55PM +0530, Durga D scratched on the wall: > >> Hi all, > >> > >> I have sqlite table with 71 columns. not null for 70 and one is > >> surrogate key(primary key). Sqlite3 3.7.9 doesn't support not null for > 70 > >> columns and unique(70 columns). It's worked fine upto 30 columns not > null > >> and unique(70 columns). > >> > >> I need 70 columns with unique and not null. How to enable it? > > > > Do you mean 70 columns that each have a single-column unique > > constraint, or a single unique constraint that crosses 70 columns? > > I think he means he has 70 columns, each of which have to be unique. > Which, of course, means he'll have 70 implicit indexes on that table. > It'll make inserting things slow, but I don't why any reason why SQLite > shouldn't do it. On the other hand, I wouldn't want to make SQLite update > 70 columns each time I INSERTed a row, and I'd probably rely on my > application to do it instead of the DBMS. > > Durga, here are the limits to the number of things you can have in SQLite: > > <http://www.sqlite.org/limits.html> > > No mention of a maximum number of indexes. But frankly I'm suspicious of > any table which has 70 columns. You should be able to hold all the columns > of a table in your head at once, and I lose my place long before 70 columns. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
