[drupal-devel] LOCK vs. SELECT FOR UPDATE
kb at 2bits.com
Tue Sep 27 15:50:02 UTC 2005
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
See here for details
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
> The problem is that you need MySQL 4 and InnoDb tables to use this.
More information about the drupal-devel