What is the difference between MyISAM Static and MyISAM Dynamic?

  • In MyISAM static all the fields will have fixed width. The Dynamic MyISAM table will have fields like TEXT, BLOB, etc. to accommodate the data types with various lengths. MyISAM Static would be easier to restore in case of corruption.

Previous Papers

Model Tests

Current Affairs

Question Answers

Related Question & Answers

How to change a password for an existing user via Mysqladmin?

How to use the MySQL slow query log?

How do you control the max size of a HEAP table?

What are the security alerts while using MySQL?

What is the difference between LIKE and REGEXP operators in MySQL?

Related Practice Tests

MySQL Interview Questions for Freshers
Categories
AndroidC programmingC++ programmingCloud ComputingComputerComputer System ArchitecureData BaseData StructureInternet & Social MediaJava programmingManual TestingMS OfficeMySQLNetworkingOperating SystemPHPProgrammingSoftware EngineeringSoftware Testing
What is the difference between MyISAM Static and MyISAM Dynamic?
Home Ask Questions Study Current Affairs Previous Papers Kerala PSCIBPSUPSCRBITNPSCMPSCSSCCBSEUnited StatesModel Tests News More Answers Coaching Centres Careers Downloads Colleges