Dan Anderson <[EMAIL PROTECTED]> wrote:
> I am having a problem in one of my scripts and I need to use
> transactions to fix it. When I looked it up on the mySQL documentation
> I found:
>
> "If you are using transaction-safe tables (like InnoDB or BDB), you can
> put MySQL into non-autocommit mode with the following command:"
>
> Does this mean that transactions will not work if I type in a CREATE
> TABLE command?
CREATE TABLE just creates new tables in the database. If you want to turn off
autocommit mode (to use transaction) you should execute SET AUTOCOMMIT=0. You can also
start transaction with BEGIN, BEGIN WORK or START TRANSACTION commands:
http://www.mysql.com/doc/en/COMMIT.html
> Are there any problems with switching to InnoDB or BDB?
There are some restrictions on InnoDB and BDB tables. They are listed at:
http://www.mysql.com/doc/en/BDB_restrictions.html
http://www.mysql.com/doc/en/InnoDB_restrictions.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
