I need to run a repair on all the tables in all my databases on my MySQL5 server because I have updated the MySQL full text search stopwords file.
我需要对MySQL5服务器上所有数据库中的所有表进行修复,因为我已经更新了MySQL全文搜索停用词文件。
Is there a query or command I can run to do this?
我可以运行查询或命令来执行此操作吗?
1 个解决方案
#1
12
Yes, you just need to query the INFORMATION_SCHEMA.STATISTICS table:
是的,您只需要查询INFORMATION_SCHEMA.STATISTICS表:
SELECT TABLE_SCHEMA, TABLE_NAME
FROM statistics
WHERE index_type LIKE 'FULLTEXT%'
#1
12
Yes, you just need to query the INFORMATION_SCHEMA.STATISTICS table:
是的,您只需要查询INFORMATION_SCHEMA.STATISTICS表:
SELECT TABLE_SCHEMA, TABLE_NAME
FROM statistics
WHERE index_type LIKE 'FULLTEXT%'