create table tablename ( colname1 coltype, colname2 coltype, colname3 coltype, PRIMARY KEY(colname1 asc, colname2 asc) )
--- On Fri, 5/29/09, Pavel Ivanov <[email protected]> wrote: From: Pavel Ivanov <[email protected]> Subject: Re: [sqlite] 2 columns as primary key? To: "General Discussion of SQLite Database" <[email protected]> Date: Friday, May 29, 2009, 10:54 PM What create table statement did you use? Pavel 2009/5/29 "Andrés G. Aragoneses" <[email protected]>: > I just tried to create a primary key with 2 columns and got this error: > > "sqlite error" "table X has more than one primary key" > > > Doesn't SQLite support this?? :o > > Andres > > -- > > _______________________________________________ > 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 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
