Locking MySQL table in PHP

[Anon]

Hi,

How can I lock a MySQL table in PHP before inserting data into it. It is possible to lock tables from the MySQL command line but, I am interested in doing the same from a PHP script.

Thanks in advance.

Krishna.

[Anon]

LOCK/UNLOCK TABLES are just sql commands as far as MySql is concerned.
You issue a separate mysql_query() to execute them.

[Anon]

The lastest versions of MySQL have transactions, also...could those help?

---John Holmes...

[Anon]

The quickest way to lock a mysql table is to issue an insert statement 🙂

If you don't get this, mysql only has table locking, not page, row, or anything better than table.

[Anon]

Hi,

you need to use this statement after database connection.

$query=mysql_query($databasename,"LOCK TABLES <tablename>");

hopefully it will work.

regards
manish

Krishna Srinivasan wrote:

Hi,

How can I lock a MySQL table in PHP before inserting data into it. It is possible to lock tables from the MySQL command line but, I am interested in doing the same from a PHP script.

Thanks in advance.

Krishna.