Cécilia Vigny <vigny.cecilia-cCSzNbf61/[EMAIL PROTECTED]>
wrote:
With MySQL, it's possible to declare an index in CREATE TABLE, using
KEY, like in this example :
CREATE TABLE table_name (
id int(6) NOT NULL auto_increment,
field_name date default NULL,
PRIMARY KEY (id),
KEY idx_field_name (fieldname),
) ;
I want to know if there is an equivalence with SQLite ?
You can put PRIMARY KEY and UNIQUE constraints either on an individual
column, or on the table (possibly listing several columns). Both
implicitly create indexes to enforce the constraint. As far as I can
tell, there is no way to create a non-unique index implicitly, without
separate CREATE INDEX statement.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
