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:
Post a Comment