Cécilia Vigny 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 ?
maybe this is what you want:
CREATE TABLE table_name (
id integer PRIMARY KEY NOT NULL,
field_name date default NULL
) ;
CREATE INDEX idx_field_name ON table_name(field_name);
also: have a look at http://www.sqlite.org/lang.html (SQL As Understood
By SQLite)
(editing your code you forgot an underscore and left an extra comma)
regards,
Mario
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
