Monday 23 June 2014

what are the database engine or what are the table types in PHP ?


what are the database engine or what are the table types in PHP ?

MYISAM
InnoDB
MERGE
Memory
Archive
CSV
Faderated
Blackhole

MYISAM :
                    is the default storage engine. The size of MYISAM table can be up to 256TB.

InnoDB:
                    InnoDB tables supports foreign keys, commit, roolback, roll and forward oparations. size can be up to 64TB.

Merge :
                   Virtual Table.

Archive:
                   Storage large number of records but allow only insert and select command.
CSV :
                   store data in comma separated values.
Federated:
                   Manage data from remote mysql server.

No comments: