hi,
to explicitly lock a row (or rows), use :
BEGIN TRAN
select ... from ... where ... FOR UPDATE;
update ...
COMMIT TRAN;
Mathias
Selon Mohammed Sameer <[EMAIL PROTECTED]>:
>
> need some urgent help
>
> im using InnoBD database type...i need to explicitly lock a row and keep it
> locked until
On 5/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> There is a variable called --network-timeout ! You can set it to 300 (5
> minutes, etc.).
SET SESSION network-timeout=120;
ERROR 1193 (HY000): Unknown system variable 'network'
How should I use network-timeout?
Thanks,
Jacob
--
MySQL G
need some urgent help
im using InnoBD database type...i need to explicitly lock a row and keep it
locked until i explicitly unlock that row..
it would be great if u could provide me with sql statements as a solution for
the above...
thanks
2005/5/22, Dan <[EMAIL PROTECTED]>:
> I just installed the 5.0.4 binary for OS X.
> Where's the client?
Most likely in /usr/local/mysql/bin/. Just add that to your $PATH.
JP
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
Hi,
I read the suggested section, but I'm not sure whether I can actually do
any debugging with the pre-compiled Windows MySQL server. Is it possible
to turn on debugging with the pre-compiled binaries on Windows?
I'm also not sure what the difference is between libmysql.lib and
mysqlclient.
Suggest you review the MySQL documentation
http://dev.mysql.com/doc/mysql/en/installing.html and in particular 2.3.13.
Testing The MySQL Installation and 2.3.14. Troubleshooting a MySQL Installation
Under Windows
Bob
-Original Message-
From: Terry Leung [mailto:[EMAIL PROTECTED]
Sent:
Dear,
I have installed MySQL4.1. But why it can not startup when I open my computer?
Also, how can I test MySQL can run or not? Thanks for your advice.
Best Regards,
Terry
My problem is the following and I thank you in advance on any help
offered. Show Innodb Status shows that my DB server has no free
buffers. What is the significance of this, what causes this, and how
bad is it?
Here is the relevant part of the output of that command:
BUFFER POOL AND MEMORY
--
