表锁读写别名 [英] TABLE LOCK Read Write ALIAS

问题描述

我正在尝试使其正常工作，但出现错误t_write was not locked.

I'm trying to get this to work but get an error t_write was not locked.

我正在从最大值sn + 1

LOCK TABLES 1_makes AS t_read READ, 1_makes as t_write WRITE;

UPDATE t_write 
SET 
    make = 'Pioneer',
    sn = (SELECT 
            *
        from
            (SELECT 
                MAX(sn)
            FROM
                t_read
            WHERE
                id <> 0) as new_sn) + 1
WHERE
    id = 2;

UNLOCK TABLES;

推荐答案

这是怎么回事:

LOCK TABLES 1_makes WRITE, 1_makes AS t_read READ;

UPDATE 1_makes
SET 
    make = 'Pioneer',
    sn = (SELECT 
            *
        from
            (SELECT 
                MAX(sn)
            FROM
                1_makes AS t_read
            WHERE
                id <> 0) as new_sn) + 1
WHERE
    id = 2;

UNLOCK TABLES;

这篇关于表锁读写别名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！