Digvijoy Chatterjee <[EMAIL PROTECTED]> wrote on 06/06/2005 10:09:15 AM:
> How do i explicilty create an innodb table ? > I tried searching thro Manual...but did not get anything important > in the create t > table section. > Thanks > DIgz > > ******************* CAUTION - Disclaimer ****************** This e- > mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended > solely for the use of the addressee(s). If you are not the intended > recipient, please notify the sender by e-mail and delete the > original message. Further, you are not to copy, disclose, or > distribute this e-mail or its contents to any other person and any > such actions are unlawful. This e-mail may contain viruses. Infosys > has taken every reasonable precaution to minimize this risk, but is > not liable for any damage you may sustain as a result of any virus > in this e-mail. You should carry out your own virus checks before > opening the e-mail or attachment. Infosys reserves the right to > monitor and review the content of all messages sent to or from this > e-mail address. Messages sent to or from this e-mail address may be > stored on the Infosys e-mail system. > ***INFOSYS******** End of Disclaimer ********INFOSYS*** End your CREATE TABLE command with an ENGINE=INNODB like this: CREATE TABLE ( .. column and index definitions here ... ) ENGINE=InnoDB; Shawn Green Database Administrator Unimin Corporation - Spruce Pine