在mysql中创建索引不起作用 [英] Create Index in mysql not working

问题描述

我正在使用MYSQL Server 5.0并且我试图使用SQL Server的下一句话并且根本不工作。请问有什么方法可以将它应用到Mysql中。非常感谢。

Im using MYSQL Server 5.0 and im trying to use the next sentence of SQL Server and is not working at all. Please is there any way to apply this to Mysql also. Thank you very much.

CREATE NONCLUSTERED INDEX [IX_Dave_General] ON [dbo].[Stock]

    (
            [ArticleID] ASC,
              [TranDate] DESC,
            [TranCode] ASC
    )
    INCLUDE ( [Items],
    [Price]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

推荐答案

原始 SQL Server 索引使用了两个功能：覆盖索引（ INCLUDE 下的非键列）和混合排序方向（ ASC 和 DESC 列）。

The original SQL Server index used two features: covering indexes (with non-key columns under INCLUDE) and mixed sort direction (ASC and DESC columns).

MySQL 都不支持这些。

如果您仍然需要索引（比如所有三列的完全匹配），请使用@ Ray的答案。

If you still need the index (say for exact matches over all three columns), use @Ray's answer.

这篇关于在mysql中创建索引不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！