mysql的index转oracle,Oracle user_indexes转换为MySQL

I have Oracle query:

SELECT index_name, table_name FROM user_indexes;

Since user_indexes is Oracle-specific view, how can I translate it to MySQL? This is my try:

DECLARE currrentDB VARCHAR(64);

SELECT DATABASE() INTO currrentDB;

SELECT INDEX_NAME, TABLE_NAME FROM information_schema.statistics s

WHERE UPPER(s.TABLE_SCHEMA) = UPPER(currrentDB);

Are these two SQL statements are equivalent?

解决方案

In Oracle user_indexes view contains informations about the indexes stored in the schema of the currently connected user.

As in Mysql SCHEMA=DB, the select proposed by you can be considered equivalent to the select from Oracle's user_indexes view.

Regards

Giova