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...

Explain the difference between MyISAM Static and MyISAM
Dynamic?

Answer Posted / amith

In MyISAM static all the fields have fixed width. The
Dynamic MyISAM table would include fields such as TEXT,
BLOB, etc. to accommodate the data types with various
lengths.

MyISAM Static would be easier to restore in case of
corruption, since even though you might lose some data, you
know exactly where to look for the beginning of the next
record.

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mysql database server?

960


Is null in mysql?

866


Is mysql case-sensitive?

886


Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4659


Does adding an index lock a table?

958


Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

1014


What is a definer?

869


What is a csv table?

1001


What is max connection in mysql?

925


How do I edit a table in mysql workbench?

846


How do I edit a stored procedure in mysql?

915


What are the technical features of MySQL?

1009


What is ndb in mysql?

961


Explain triggers and stored procedures?

918


explain GROUPBY & HAVING clause with examples.

2282