mySQL LOCK TABLES

[medine]

Hi folks,

I'm looking for some advice on how to lock tables with perl and mySQL?

After makeing a connection, I can lock a table with the following code:-

$dbh->do('LOCK TABLES user WRITE');

This works fine if I try and access the user table with the same $dbh handle, but when I log on useing a different $dbh handle, there is no lock on the table and I can access and update records.

Any thoughts, your help would be much appreciated.

Cal

 

[missbarbell]

This sounds like a MySQL issue rather than a Perl issue. Have look at the docs on the MySQL [1] site regarding table locking [2]

[1]

http://www.mysql.com/doc/en/index.html

[2]

http://www.mysql.com/doc/en/Table_locking.html

Barbie
Leader of Birmingham Perl Mongers

http://birmingham.pm.org

 

[medine]

Thanks for your reply Barbie,

I've read over all I can find on mySQL's documentation and I still can't figure out why it will not work?

Cal