Re: MySQL/Query question, help.

[Petro <petro@auctionwatch.com>]

On Wed, May 22, 2002 at 02:59:20PM +0800, louie miranda wrote:

    First off, if you're going to ask a new question don't reply to a
    pre-existing thread and just change the subject, also delete the
    "In-Reply-To:" header. 

> Hi, i was just wondering... i have inserted 1 row on my table,
> how come when i did lock table. Mysql did not see one of my insert.

    That makes no sense. 


> Please check mail below, thanks.
> mysql> select * from louie2;
> +----+-----------+
> | id | firstname |
> +----+-----------+
> |  1 | louie     |
> +----+-----------+
> 1 row in set (0.00 sec)
> 
> mysql> lock table louie read;
> Query OK, 0 rows affected (0.00 sec)

    Mysql did the right thing. Your expectations are wrong. 

    Locking a table does not modify or effect rows, it just locks the
    table. 

    e.g.: 
    mysql> purge master logs to 'log.128';
    Query OK, 0 rows affected (2.32 sec)

    mysql> 

    Doesn't effect any rows either. 

    Try reading the relevant parts of the manual (I would say read the
    whole manual, but it *is* a bit overwhelming in this case). 


-- 
My last cigarette was roughly 30 days, 13 hours, 43 minutes ago.
YHBW


-- 
To UNSUBSCRIBE, email to debian-user-request@lists.debian.org 
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org