Igor Tandetnik a écrit :
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
Thank you !
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
Ce message est protégé par les règles relatives au secret des correspondances.
Il est donc établi à destination exclusive de son destinataire. Celui-ci peut
donc contenir des informations confidentielles. La divulgation de ces
informations est à ce titre rigoureusement interdite. Si vous avez reçu ce
message par erreur, merci de le renvoyer à l'expéditeur dont l'adresse e-mail
figure ci-dessus et de détruire le message ainsi que toute pièce jointe.
This message is protected by the secrecy of correspondence rules. Therefore,
this message is intended solely for the attention of the addressee. This
message may contain privileged or confidential information, as such the
disclosure of these informations is strictly forbidden. If, by mistake, you
have received this message, please return this message to the addressser whose
e-mail address is written above and destroy this message and all files attached.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
