关于MySQL ERROR 1146 Table doesnt exist的解析

#define DICT_TF_WIDTH_ZIP_SSIZE 4

/** Width of the ATOMIC_BLOBS flag. The Antelope file formats broke up

BLOB and TEXT fields, storing the first 768 bytes in the clustered index.

Barracuda row formats store the whole blob or text field off-page atomically.

Secondary indexes are created from this external data using row_ext_t

to cache the BLOB prefixes. */

#define DICT_TF_WIDTH_ATOMIC_BLOBS 1

/** If a table is created with the MYSQL option DATA DIRECTORY and

innodb-file-per-table, an older engine will not be able to find that table.

This flag prevents older engines from attempting to open the table and

allows InnoDB to update_create_info() accordingly. */

#define DICT_TF_WIDTH_DATA_DIR 1

/** Width of the SHARED tablespace flag.

It is used to identify tables that exist inside a shared general tablespace.

If a table is created with the TABLESPACE=tsname option, an older engine will

not be able to find that table. This flag prevents older engines from attempting

to open the table and allows InnoDB to quickly find the tablespace. */

#define DICT_TF_WIDTH_SHARED_SPACE 1

如不雅报错出现我们须要起首查看的是INNODB_SYS_TABLES是否包含了这个表的信息。也许在这些数据字典中也许某些列并显示并不是那么明白，比如

mysql> select * from information_schema.innodb_sys_tables 	
			 2/7   首页 上一页 1 2 3 4 5 6 下一页 尾页	
			

　　推荐阅读
　　因为这些原因 让你讨厌DIY装机吗？
            DIY就是靠你本身着手做的意思，这意味着DIY拥有很大年夜的自由度和那份无人能赐与的成就感，但当然了，伴跟着的也拥有必定的难度与障碍。对于我们DIY装机来说，那些DIY玩家应当也就是凭借着前面所说那份>>>详细阅读


本文标题：关于MySQL ERROR 1146 Table doesnt exist的解析
地址：http://www.17bianji.com/lsqh/37797.html
 1/2    1