Transactions, Locks, Begin, InnoDB

[Shak]

Hi,

I'm struggling to get to grips with all the different ways in which you can
work concurrently in MySQL. Different parts of the manual describe different
methods, as do different tutorials.

What's the difference between START TRANSACTION and BEGIN?

What's the difference between TABLE LOCKs and InnoDB locks?

Thanks!

Shak

[toby]

On Jul 23, 5:51 am, "Shak" <S...@shak.com> wrote:
> Hi,
>
> I'm struggling to get to grips with all the different ways in which you can
> work concurrently in MySQL. Different parts of the manual describe different
> methods, as do different tutorials.
>
> What's the difference between START TRANSACTION and BEGIN?

As the manual will tell you, none, other than that the former is
standard SQL.

>
> What's the difference between TABLE LOCKs and InnoDB locks?

InnoDB uses implicit or explicit row level locking. You can read more
about this under
http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-model.html

You can read more about table locking, as used by other engines, under
http://dev.mysql.com/doc/refman/5.0/en/table-locking.html

>
> Thanks!
>
> Shak