> table:
> title_id bigint(50),title char(200), cdate datetime
>
> query:
> select title, max(cdate) as mdt, count(title_id) as
> num
> from entry
> where (date_format(cdate, '%Y-%m-%d %H:%i:%s')
> between '2004-05-07 00:00:01' AND '2004-05-08
> 23:59:59')
> and
> (on = 'Y')
> group by title
> ord
Hi,
Can someone clarify the following.
When I use statement
LOCK TABLES t1 WRITE, t2 READ, ...;
Am I garanteed that locking will be performed in the
order t1, t2, etc.? If not, use of this on multiple
threads will produce locks. Manual says to use this
statement, but it does not say if the order
