Michael,
- Original Message -
From: "Michael Bacarella" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
> > SELECT * FROM mytable WHERE mycol = xxx LOCK IN SHARE MODE;
> >
> > or
> >
> > SELECT * FROM mytable WHERE mycol = xxx FOR UPDATE;
> >
> >
> > The
On Fri, Jun 21, 2002 at 12:38:06AM +0300, Heikki Tuuri wrote:
> InnoDB type tables in MySQL have row level locking. Call SET AUTOCOMMIT=0 or
> wrap your transaction in BEGIN ... COMMIT.
>
> Make sure you have an index on column 'mycol' so that InnoDB finds the row
> without a table scan. Then you
find a lot of
> this type of programming. I now rely much more on transactions to keep
> things straight. Yes, this means that two users could issue updates almost
> at the same time. Last one to the database wins.
>
> HTH,
> =C=
>
> -Original Message-
> From:
t one to the database wins.
HTH,
=C=
-Original Message-
From: Silmara Cristina Basso [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 19, 2002 1:10 PM
To: [EMAIL PROTECTED]
Subject: locking on row level ...
I'm newbie MySQL and I'm using MySQL-max 4.0.1(Innodb), with one application
Hi!
- Original Message -
From: "Galen Wright-Watson" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, June 20, 2002 11:32 PM
Subject: Re: locking on row level ...
>
> On Wed, 19 Jun 2002, Silmara Cristina Basso wrote:
>
> > I'm
On Wed, 19 Jun 2002, Silmara Cristina Basso wrote:
> I'm newbie MySQL and I'm using MySQL-max 4.0.1(Innodb), with one application
> developed in Delphi and connect through MyODBC. The question is ...
> How can i do to lock one row so that it is editing in the application?
>
>
The impression I g
