What are heap tables?

HEAP tables are present in memory and they are used for high speed storage on temporary basis.

  • BLOB or TEXT filds are not allowed
  • Only comparison operators can be used =, <, >, => , =<
  • AUTO_INVREMENT is not supported by HEAP tables
  • Indexes should be not null

The default port for Mysql server is 3306