activeperl@listserv.ActiveState.com
[Top] [All Lists]

Re: Lock my database

Subject: Re: Lock my database
From: "Petr Vileta"
Date: Wed, 20 Oct 2004 01:25:09 +0200
> First of all i use mysql database.
>
> Does anyone know a way to lock a specific table when i run a perl script
that updates this table?
> By the time that script updates this table some users might be use it.
LOCK TABLES table1 [READ|WRITE] [, table2 [READ|WRITE] ] ...

and after update do not forget to UNLOCK TABLES :-)
Look for LOCK TABLE in MySQL manual.

Petr Vileta, Czech republic

_______________________________________________
ActivePerl mailing list
ActivePerl@xxxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

<Prev in Thread] Current Thread [Next in Thread>