Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

What are HEAP tables in MySQL?

Question Posted / amith

Answer Posted / amith

HEAP tables are in-memory. They are usually used for high-
speed temporary storage. No TEXT or BLOB fields are allowed
within HEAP tables.

we can only use the comparison operators = and <=>. HEAP
tables do not support AUTO_INCREMENT. Indexes must be NOT
NULL.

Is This Answer Correct ?    15 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

956

What is indexing in mysql?

878

What are date and time data types in mysql?

954

What is difference between mysql and mysql workbench?

874

How to calculate the difference between two dates?

976

Explain the different types of mysql joins.

851

How to insert html code into mysql database using php?

994

What is difference between group by and order by clause?

908

What is view in mysql?

923

What are the steps required to view your mysql database?

1033

What is ndb in mysql?

903

How to create and drop view in mysql?

856

What is slow query log in mysql?

1028

Define REGEXP?

1034

Is mysql open source?

858