Tuesday, December 8, 2009

HEAP tables in MySQL

HEAP tables in MySQL

HEAP tables are in-memory. They are usually used for high-speed temporary storage. No TEXT or BLOB fields are allowed within HEAP tables. You can only use the comparison operators = and <=>. HEAP tables do not support AUTO_INCREMENT. Indexes must be NOT NULL.

No comments:

Post a Comment

If you are really interested about our blogger, Please Share your opinion here ...

If you Found Any Interviews in your reliable sources, Please Post the information through this Comment and It will be Published in our blogger. help every one to get a Job.