Search
| 1 to 5 of 5 |
MySQL.com Search Results
1. MySQL :: MySQL 6.0 Reference Manual :: 12.1.7 CREATE INDEX Syntax
12.1.7. CREATE INDEX Syntax CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name [ index_type ] ON tbl_name ( index_col_name ,...) [ index_option ] ... index_col_name : col_name [( length )] [ASC | DESC] index_type : USING {BTREE | HASH | RTREE} index_option : KEY_BLOCK_SIZE [=] value | index_type | WITH PARSER parser_name | COMMENT ' string ' CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. See Section 12.1.4, “ ALTER TABLE Syntax” . CREATE INDEX cannot be used to create a PRIMARY KEY ;
» http://dev.mysql.com/doc/refman/6.0/en/create-index.html
2. MySQL :: MySQL 5.1 Reference Manual :: 12.1.7 CREATE INDEX Syntax
12.1.7. CREATE INDEX Syntax CREATE [ONLINE|OFFLINE] [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name [ index_type ] ON tbl_name ( index_col_name ,...) [ index_option ] ... index_col_name : col_name [( length )] [ASC | DESC] index_type : USING {BTREE | HASH | RTREE} index_option : KEY_BLOCK_SIZE [=] value | index_type | WITH PARSER parser_name CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. See Section 12.1.4, “ ALTER TABLE Syntax” . CREATE INDEX cannot be used to create a PRIMARY KEY ; use
» http://dev.mysql.com/doc/refman/5.1/en/create-index.html
3. MySQL :: MySQL 5.0 Reference Manual :: 12.1.4 CREATE INDEX Syntax
12.1.4. CREATE INDEX Syntax CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name [ index_type ] ON tbl_name ( index_col_name ,...) [ index_type ] index_col_name : col_name [( length )] [ASC | DESC] index_type : USING {BTREE | HASH | RTREE} CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. See Section 12.1.2, “ ALTER TABLE Syntax” . CREATE INDEX cannot be used to create a PRIMARY KEY ; use ALTER TABLE instead. For more information about indexes, see Section 7.4.5, “How MySQL Uses Indexes” .
» http://dev.mysql.com/doc/refman/5.0/en/create-index.html
4. MySQL :: MySQL 5.1 with Maria Reference Manual :: 12.1.7 CREATE INDEX Syntax
12.1.7. CREATE INDEX Syntax CREATE [ONLINE|OFFLINE] [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name [ index_type ] ON tbl_name ( index_col_name ,...) [ index_option ] ... index_col_name : col_name [( length )] [ASC | DESC] index_type : USING {BTREE | HASH | RTREE} index_option : KEY_BLOCK_SIZE [=] value | index_type | WITH PARSER parser_name CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. See Section 12.1.4, “ ALTER TABLE Syntax” . CREATE INDEX cannot be used to create a PRIMARY KEY ; use
» http://dev.mysql.com/doc/refman/5.1-maria/en/create-index.html
5. MySQL :: MySQL 3.23, 4.0, 4.1 Reference Manual :: 12.1.4 CREATE INDEX Syntax
12.1.4. CREATE INDEX Syntax CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name [ index_type ] ON tbl_name ( index_col_name ,...) index_col_name : col_name [( length )] [ASC | DESC] index_type : USING {BTREE | HASH} In MySQL 3.22 or later, CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. See Section 12.1.2, “ ALTER TABLE Syntax” . The CREATE INDEX statement does not do anything prior to MySQL 3.22. For more information about indexes, see Section 7.4.5, “How MySQL Uses Indexes” . Normally
» http://dev.mysql.com/doc/refman/4.1/en/create-index.html
| 1 to 5 of 5 |