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

Write a query to count the number of rows of a table in mysql.

929

What is unsigned int in mysql?

920

What are the differences between a primary key and foreign key?

1087

How does mysql store data?

933

What is a delimiter in mysql?

1016

What are the difference between and myisam and innodb?

1017

What is the return type of mysqli_query?

862

What is dump in mysql?

877

What is a result set object?

948

What is the usage of regular expressions in mysql?

899

What is logs in mysql?

886

How do I edit a table in mysql workbench?

846

Why do we use mysql?

930

How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.

1055

Write a query to fetch common records between two tables using mysql?

1021