Hi geniuses, i have 2 server A & B both have mysql running, is there anyway if i want to use web application on A and connect mysql on B.
I think i need some code example, thanks ----- Original Message ----- From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 30, 2003 4:50 PM Subject: Re: Enabling Transactions > 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] >
___________________________________________________________________________________________________________________________________________________________________ This mail is protected by Silicon Communications S/B The information contained in this message maybe confidential and protected from disclosure. If you are not the intended recipient of this message, please delete this message immediately. You are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. ~~~This email has been scanned by our anti-virus system. For precaution, please make sure you scan every attachment in this email. Please use at your own risk. Thank you. :) Mailadmin~~~ ___________________________________________________________________________________________________________________________________________________________________
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]