What are the different table present in MYsql?

Answer Posted / subrat

MyISAM: This is default. Based on Indexed Sequntial Access
Method. The above SQL will create a MyISA table.
ISAM : same
HEAP : Fast data access, but will loose data if there is a
crash. Cannot have BLOB, TEXT & AUTO INCRIMENT fields
BDB : Supports Transactions using COMMIT & ROLLBACK. Slower
that others.
InoDB : same as BDB

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create table in stored procedure?

683


How do I edit a stored procedure in mysql?

664


How can an index be declared in mysql?

632


How do I delete a row in mysql?

694


Is mysqli deprecated?

658


Can you tell a way to know the number of days between the two given dates in php?

780


What is mysql connection limit?

680


how you will Create a database on the mysql server with unix shell.

741


Why should I learn mysql?

670


How do I show columns in mysql?

682


What is delimiter in mysql stored procedure?

664


What is definer in mysql trigger?

668


What are slow queries?

648


What is the datatype of image?

702


What are mysql queries?

685