What are HEAP tables in MySQL?

devquora
devquora

Posted On: Feb 22, 2018

 

    1 Answer Written

  •  devquora
    Answered by Farheen

    Heap tables are usually used for the purpose of temporary and high-speed temporary storage. Heap tables can also be defined as in-memory. Within heap tables, BLOB or TEXT fields are not allowed. Only comparison operators like = and <=> can be used. The indexes have to be NOT NULL and these tables do not upkeep AUTO_INCREMENT.

Related Questions

Please Login or Register to leave a response.

Related Questions

Mysql Interview Questions

What is MySql ?

MySql is a multi-threading, multi-user open source SQL database management system . It is typically used for web applica..

Mysql Interview Questions

In which language MYSQL it is written ?

MySql is written in C and C++ programming and SQL parser written in yacc...