首页 > 代码库 > TEXT和BLOB区别

TEXT和BLOB区别

  • Instances of BLOB or TEXT columns in the result of a query that is processed using a temporary table causes the server to use a table on disk rather than in memory because the MEMORY storage engine does not support those data types (see Section 8.4.4, “How MySQL Uses Internal Temporary Tables”). Use of disk incurs a performance penalty, so include BLOB or TEXT columns in the query result only if they are really needed. For example, avoid using SELECT *, which selects all columns.

 

【参考资料】

1、http://dev.mysql.com/doc/refman/5.6/en/blob.html

TEXT和BLOB区别