MySQL Forums
Forum List  »  Newbie

Suggestable Engine
Posted by: Mohit Goyal
Date: December 21, 2010 05:35AM

Hi Experts,

First of all, met me tell that I am working on DB2 and very new to MYSQL, but some of my application is running on MYSQL.

Following are the queries-

1. I want to know what excatly the differnce between INNODB Engine and MYISM Engine.
2. Which one is suggested in what scenario?
3. I have a table which have 5 columns.Out of those 5 columns, there is a column called Sl which is AUTOINCREMENT and obviuosly a Primary key. The table is created under INNODB Engine.

If I insert 10 rows in to the table and after some time if I delete those 10 rows and insert 5 new rows, What will happen to SL column.How will it behave.

4. How AUTOINCREMENT is different in both the Engines? Which one is suggestable in my scenario?

Options: ReplyQuote


Subject
Written By
Posted
Suggestable Engine
December 21, 2010 05:35AM
December 22, 2010 04:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.