mysql+create+table+index_如何用索引创建MySQL表？

要创建带有索引的MySQL表，语法如下-create table yourTableName

(

yourColumnName1 dataType,

yourColumnName2 dataType

.

.

.

N

);

create index yourIndexName1 on(yourColumnName1 );

create index yourIndexName2 on(yourColumnName2 );

让我们首先创建一个表-mysql> create table DemoTable

-> (

-> Id int,

-> Name varchar(20)

-> );

这是使用表创建索引的查询-mysql> create index id_index on DemoTable(Id);

Records: 0 Duplicates: 0 Warnings: 0

mysql> create index Name_index on DemoTable(Name);

Records: 0 Duplicates: 0 Warnings: 0

现在您可以检查表的结构-mysql> show create table DemoTable;

这将产生以下输出-+---------------+-----------------------------------------------------------------------------------------+

| Table         | Create Table                                                                            |

+---------------+-----------------------------------------------------------------------------------------+

| DemoTable     | CREATE TABLE `DemoTable` ( `Id` int(11) DEFAULT NULL, `Name` varchar(20) COLLATE                               utf8_unicode_ci DEFAULT NULL, KEY `id_index` (`Id`), KEY `Name_index` (`Name`) )                            ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci                             |

+---------------+------------------------------------------------------------------------------------------+

1 row in set (0.05 sec)