lock a table

Forum related to MySQL

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
spduvalis
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 18.04.2006, 11:19

lock a table

Post by spduvalis »

Hi,
I would like to know how to lock a table and then execute some queries
(e.g. insert new record) and after that unlock table using one or more queries.
I work with delphi 7 and zeos 6.5.1.
Thank you
btrewern
Expert Boarder
Expert Boarder
Posts: 193
Joined: 06.10.2005, 18:51

Post by btrewern »

You could use transactions to do something similar. What database are you using and what exactly are you trying to do?

Regards,

Ben
mparak
Senior Boarder
Senior Boarder
Posts: 81
Joined: 12.09.2005, 06:51
Location: Durban South Africa
Contact:

Post by mparak »

Sit back and let MySQL handle the locks and you will be amazed.
Let the technology do the heavy lifting for you.

Mohammed Parak
CAD RETAIL
Durban South Africa
www.cad.co.za
Post Reply