重庆思庄Oracle、Redhat认证学习论坛

标题: 检索数据时去除表格视图。 [打印本页]

作者: jikcheng    时间: 2014-11-9 17:17
标题: 检索数据时去除表格视图。
 mysql> show plugins;
+----------------------------+----------+--------------------+---------+-------------+
| Name                       | Status   | Type               | Library | License     |
+----------------------------+----------+--------------------+---------+-------------+
| binlog                     | ACTIVE   | STORAGE ENGINE     | NULL    | PROPRIETARY |
| mysql_native_password      | ACTIVE   | AUTHENTICATION     | NULL    | PROPRIETARY |
| mysql_old_password         | ACTIVE   | AUTHENTICATION     | NULL    | PROPRIETARY |
| sha256_password            | ACTIVE   | AUTHENTICATION     | NULL    | PROPRIETARY |
| MyISAM                     | ACTIVE   | STORAGE ENGINE     | NULL    | PROPRIETARY |
| MEMORY                     | ACTIVE   | STORAGE ENGINE     | NULL    | PROPRIETARY |
| CSV                        | ACTIVE   | STORAGE ENGINE     | NULL    | PROPRIETARY |
| MRG_MYISAM                 | ACTIVE   | STORAGE ENGINE     | NULL    | PROPRIETARY |
| FEDERATED                  | DISABLED | STORAGE ENGINE     | NULL    | PROPRIETARY |
| InnoDB                     | ACTIVE   | STORAGE ENGINE     | NULL    | PROPRIETARY |
| INNODB_TRX                 | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_LOCKS               | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_LOCK_WAITS          | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_CMP                 | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_CMP_RESET           | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_CMPMEM              | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_CMPMEM_RESET        | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_CMP_PER_INDEX       | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_CMP_PER_INDEX_RESET | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_BUFFER_PAGE         | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_BUFFER_PAGE_LRU     | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_BUFFER_POOL_STATS   | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_METRICS             | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_FT_DEFAULT_STOPWORD | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_FT_DELETED          | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_FT_BEING_DELETED    | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_FT_CONFIG           | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_FT_INDEX_CACHE      | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_FT_INDEX_TABLE      | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_SYS_TABLES          | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_SYS_TABLESTATS      | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_SYS_INDEXES         | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_SYS_COLUMNS         | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_SYS_FIELDS          | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_SYS_FOREIGN         | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_SYS_FOREIGN_COLS    | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_SYS_TABLESPACES     | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| INNODB_SYS_DATAFILES       | ACTIVE   | INFORMATION SCHEMA | NULL    | PROPRIETARY |
| BLACKHOLE                  | ACTIVE   | STORAGE ENGINE     | NULL    | PROPRIETARY |
| PERFORMANCE_SCHEMA         | ACTIVE   | STORAGE ENGINE     | NULL    | PROPRIETARY |
| ARCHIVE                    | ACTIVE   | STORAGE ENGINE     | NULL    | PROPRIETARY |
| partition                  | ACTIVE   | STORAGE ENGINE     | NULL    | PROPRIETARY |
+----------------------------+----------+--------------------+---------+-------------+
42 rows in set (0.00 sec)

mysql> show plugins\G
*************************** 1. row ***************************
   Name: binlog
 Status: ACTIVE
   Type: STORAGE ENGINE
Library: NULL
License: PROPRIETARY
*************************** 2. row ***************************
   Name: mysql_native_password
 Status: ACTIVE
   Type: AUTHENTICATION
Library: NULL
License: PROPRIETARY
*************************** 3. row ***************************
   Name: mysql_old_password
 Status: ACTIVE
   Type: AUTHENTICATION
Library: NULL
License: PROPRIETARY
*************************** 4. row ***************************
   Name: sha256_password
 Status: ACTIVE
   Type: AUTHENTICATION
Library: NULL
License: PROPRIETARY
*************************** 5. row ***************************
   Name: MyISAM
 Status: ACTIVE
   Type: STORAGE ENGINE
Library: NULL
License: PROPRIETARY
*************************** 6. row ***************************
   Name: MEMORY
 Status: ACTIVE
   Type: STORAGE ENGINE
Library: NULL
License: PROPRIETARY
*************************** 7. row ***************************
   Name: CSV
 Status: ACTIVE
   Type: STORAGE ENGINE
Library: NULL
License: PROPRIETARY
*************************** 8. row ***************************
   Name: MRG_MYISAM
 Status: ACTIVE
   Type: STORAGE ENGINE
Library: NULL
License: PROPRIETARY
*************************** 9. row ***************************
   Name: FEDERATED
 Status: DISABLED
   Type: STORAGE ENGINE
Library: NULL
License: PROPRIETARY
*************************** 10. row ***************************
   Name: InnoDB
 Status: ACTIVE
   Type: STORAGE ENGINE
Library: NULL
License: PROPRIETARY
*************************** 11. row ***************************
   Name: INNODB_TRX
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 12. row ***************************
   Name: INNODB_LOCKS
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 13. row ***************************
   Name: INNODB_LOCK_WAITS
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 14. row ***************************
   Name: INNODB_CMP
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 15. row ***************************
   Name: INNODB_CMP_RESET
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 16. row ***************************
   Name: INNODB_CMPMEM
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 17. row ***************************
   Name: INNODB_CMPMEM_RESET
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 18. row ***************************
   Name: INNODB_CMP_PER_INDEX
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 19. row ***************************
   Name: INNODB_CMP_PER_INDEX_RESET
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 20. row ***************************
   Name: INNODB_BUFFER_PAGE
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 21. row ***************************
   Name: INNODB_BUFFER_PAGE_LRU
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 22. row ***************************
   Name: INNODB_BUFFER_POOL_STATS
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 23. row ***************************
   Name: INNODB_METRICS
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 24. row ***************************
   Name: INNODB_FT_DEFAULT_STOPWORD
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 25. row ***************************
   Name: INNODB_FT_DELETED
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 26. row ***************************
   Name: INNODB_FT_BEING_DELETED
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 27. row ***************************
   Name: INNODB_FT_CONFIG
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 28. row ***************************
   Name: INNODB_FT_INDEX_CACHE
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 29. row ***************************
   Name: INNODB_FT_INDEX_TABLE
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 30. row ***************************
   Name: INNODB_SYS_TABLES
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 31. row ***************************
   Name: INNODB_SYS_TABLESTATS
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 32. row ***************************
   Name: INNODB_SYS_INDEXES
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 33. row ***************************
   Name: INNODB_SYS_COLUMNS
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 34. row ***************************
   Name: INNODB_SYS_FIELDS
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 35. row ***************************
   Name: INNODB_SYS_FOREIGN
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 36. row ***************************
   Name: INNODB_SYS_FOREIGN_COLS
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 37. row ***************************
   Name: INNODB_SYS_TABLESPACES
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 38. row ***************************
   Name: INNODB_SYS_DATAFILES
 Status: ACTIVE
   Type: INFORMATION SCHEMA
Library: NULL
License: PROPRIETARY
*************************** 39. row ***************************
   Name: BLACKHOLE
 Status: ACTIVE
   Type: STORAGE ENGINE
Library: NULL
License: PROPRIETARY
*************************** 40. row ***************************
   Name: PERFORMANCE_SCHEMA
 Status: ACTIVE
   Type: STORAGE ENGINE
Library: NULL
License: PROPRIETARY
*************************** 41. row ***************************
   Name: ARCHIVE
 Status: ACTIVE
   Type: STORAGE ENGINE
Library: NULL
License: PROPRIETARY
*************************** 42. row ***************************
   Name: partition
 Status: ACTIVE
   Type: STORAGE ENGINE
Library: NULL
License: PROPRIETARY
42 rows in set (0.01 sec)

mysql>





欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2