List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:June 17 2001 3:32pm
Subject:RE: transactions managment
View as plain text  
At 4:39 PM +0200 6/17/01, Ismael Touama wrote:
>Hi,
>
>little bit confuse...
>
>In your book it's written, MySQL doesn't support (from p.188 to p.193):
>	-subselect
>	-transaction and commit/rollback
>	-FOREIGN KEY ...
>	-PROC stocked on the server side and TRIGGER
>
>And I read it, on the manual...
>Even if solution are given (LOCK, UNLOCK TABLE), I don't understand that
>MySQL is able to put the database in its initial state when an error occurs
>during an update (a manipulation) of its data.
>
>I'm with binary version 3.23.38.
>I'm sorry but I guess I don't really understand what's under.

Transaction support was added after publication of the book.

>
>Isma.
>
>
>
>-----Message d'origine-----
>De : Paul DuBois [mailto:paul@stripped]
>Envoye : samedi 16 juin 2001 22:07
>A : Harkins; win32@stripped
>Objet : Re: transactions managment
>
>
>At 3:59 PM -0400 6/16/01, Harkins wrote:
>>Oh, I see, you're referring to MaxSQL.
>>
>>I could argue that the need for special tables, etc. negates true
>>inclusion/support of the feature,
>
>Well, it's really no different than the need to use MyISAM tables to get
>around the limitations of ISAM tables such as the inability to include
>NULL values in indexed columns.
>
>
>>but then I know everyone has an opinion,
>>and mine stinks. :)
>
>No comment. :-)
>
>>
>>slh
>>
>>
>>>   At 2:49 PM -0400 6/16/01, Harkins wrote:
>>>   >===========A version of MySQL does support transactions? Can you
>expound?
>>I
>>>   >wasn't aware that any version supported transactions.
>>>
>>>   Since something like 3.23.15 or so.  Grab a current Windows distribution
>>>   and run one of the servers with -max in its name.
>>>
>>>   http://www.mysql.com/doc/W/i/Windows_installation.html
>>>
>>>   >
>>>   >slh
>>>   >>  Perhaps your version of MySQL is older and doesn't support
>>transactions,
>>>   >  > or isn't configured to include transaction support? Can you
>upgrade?
>>>
>>>
>>>   --
>>   > Paul DuBois, paul@stripped
>
>
>--
>Paul DuBois, paul@stripped


-- 
Paul DuBois, paul@stripped
Thread
transactions managmentIsmael Touama16 Jun
  • Re: transactions managmentPaul DuBois16 Jun
    • RE: transactions managmentIsmael Touama16 Jun
      • RE: transactions managmentPaul DuBois16 Jun
      • Re: transactions managmentHarkins16 Jun
        • Re: transactions managmentPaul DuBois16 Jun
      • Re: transactions managmentHarkins16 Jun
        • Re: transactions managmentPaul DuBois16 Jun
          • RE: transactions managmentIsmael Touama17 Jun
            • RE: transactions managmentPaul DuBois17 Jun
RE: transactions managmentIsmael Touama17 Jun