[drupal-devel] LOCK vs. SELECT FOR UPDATE

[Khalid B]

There are many cases where MySQL supports the syntax but not the functionality.

It silently accepts what you enter (whether it is data definition or
queries) but it does not do what you think it should do.

Most of this has to do with using MyISAM tables but features that only
in InnoDB.

See here for details
http://sql-info.de/mysql/gotchas.html


On 9/27/05, Nicolas Tostin <nicolast at logis.com.mx> wrote:
> > until now we've largely ignored people who aren't allowed to lock their
> > tables and thus cannot use Drupal. Somebody suggested
> > (http://drupal.org/node/1190#comment-55984) to use SELECT FOR
> > UPDATE in database.mysql.inc instead. Is there any database expert who can
> > comment on the pros and cons of the approach?
>
> I remember we discuss this a few monthes ago see
> http://drupal.org/node/21439
> The problem is that you need MySQL 4 and InnoDb tables to use this.
>
>