重庆思庄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