【7】MySQL Case-information_schema视图查询慢处理一例.docxVIP

07 07 、MySQL Case-information_schema 视图查询 慢处理一例. 慢处理一例. sql文本如下： SELECT c.TABLE_SCHEMA, c.TABLE_NAME, c.COLUMN_NAME, c.COLUMN_TYPE, c.IS_NULLABLE, c.COLUMN_COMMENT, c.ORDINAL_POSITION,( CASE WHEN c.EXTRA = STORED GENERATED THEN concat( GENERATED ALWAYS AS (, c.GENERATION_EXPRESSION, ) STORED ) WHEN