如何用索引创建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)