Hi!
At 10:12 2002.09.24._ +0100, you wrote:
>Question is, will this
>require any SQL code changes to our application? We make heavy use of
>features like temporary tables, autoincrement columns etc. Would if be
>as simple as dumping the database and restoring it to InnoDB tables?
The simple answer is: No. You don't have to change any code in your
application, InnoDB will works with the actual code, because it is 100%
compatible with MyISAM.
But!!! If you want to use special features of InnoDB table types (which are
not in MyISAM), you might need changing your code. For example when you
decide to use transactions (non-autocommit mode) or foreign key constraints.
Bye,
Daniel
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
