查看当前表顺序 [英] view current table order

问题描述

在 phpmyadmin 中有一个选项可以改变当前表的顺序....我怎么知道当前的顺序是什么?

In phpmyadmin there is an option to alter the current table order....how can I know what the current order is?

推荐答案

你不能.没有这种东西.

You can't. There is no such thing.

准确地说:在 MyISAM 引擎中，当前顺序是上次执行 ALTER TABLE ORDER BY 时的顺序，此后的所有删除和插入都被修改.

To be precise: in MyISAM engine, current order is whatever the order was when the last ALTER TABLE ORDER BY was performed, modified by all the deletions and insertions since.

InnoDB 只是按照自己的意愿对表进行排序.

InnoDB just sorts the tables as it wishes.

这篇关于查看当前表顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！