如何创建带索引的 MySQL 表?
mysqlmysqli database更新于 2024/1/30 14:43:00
要创建带索引的 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) -> ); Query OK, 0 rows affected (0.63 sec)
这是使用表创建索引的查询 −
mysql> create index id_index on DemoTable(Id); Query OK, 0 rows affected (0.36 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> create index Name_index on DemoTable(Name); Query OK, 0 rows affected (0.38 sec) 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)
