Answer:- ALTER is a DDL (Data Definition Language) statement. Whereas UPDATE
is a DML (Data Manipulation Language) statement. One is used to update
the structure of the table (add/remove field/index etc). Whereas UPDATE
is used to update data.
Wednesday, 15 April 2015
What is difference between innodb and myIsam?
Ans:
1) InnoDB implements row-level lock while MyISAM can do only a table-level lock.
2) InnoDB provides better crash recovery compared to MyISAM.
3) InnoDB doesn’t have FULLTEXT search indexes, whereas MyISAM does.
4) InnoDB supports transactions, foreign keys and relationship constraints while MyISAM does not.
1) InnoDB implements row-level lock while MyISAM can do only a table-level lock.
2) InnoDB provides better crash recovery compared to MyISAM.
3) InnoDB doesn’t have FULLTEXT search indexes, whereas MyISAM does.
4) InnoDB supports transactions, foreign keys and relationship constraints while MyISAM does not.
Subscribe to:
Posts (Atom)