"Sam Carleton" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I am trying to create a table with two indexes: > > CREATE TABLE favorites ( > cust_id CHAR(32) NOT NULL, > fldoid CHAR(38) NOT NULL, > imgoid CHAR(64) NOT NULL, > PRIMARY KEY (cust_id), > INDEX (fldoid, imgoid)); > > SQLite keeps complaining saying there is an error around INDEX. What > might I be doing wrong?
Here's the syntax of CREATE TABLE statement: http://sqlite.org/lang_createtable.html INDEX is not a valid keyword in such a statement. Did you perhaps mean UNIQUE? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users