Check out the GET_LOCK and RELEASE_LOCK virtual lock functions in MySQL.
-Hank
On Wed, Sep 28, 2011 at 9:15 AM, Alex Schaft wrote:
> Hi,
>
> We're busy moving legacy apps from foxpro tables to mysql. User logins were
> tracked via a record in a table which the app then locked, preventing
> mul
On Mon, 2010-09-27 at 11:25 +0100, Willy Mularto wrote:
> Hi,
> I work on MySQL 5 with PHP 5 and use Apache 2 as the webserver. I have a
> simple query that searches matched row id and update the field via HTTP GET
> query. On a low load it succeed update the row. But on high traffic sometimes
Craig Cummings <[EMAIL PROTECTED]> wrote:
>>Description:
>
> When inserting large strings into ISAM table in an UPDATE TABLE
> command, my perl script generates an "Out of memory error". I tracked
> this down using an SQL script (below). It seems that a 32777225
> character string is tolerated,
Sounds like there is a misunderstanding about what exactly a data type can
do. What you can't do is change the 'type' of a column with an UPDATE
command. You can do it with an ALTER TABLE command, but this would be a
_misuse_ of the command, given what you are trying to do.
You have one of 2 optio
How do i use the UPDATE statement to update a range of Primary Key id
numbers. (let say 100 through 1000).
Example,
UPDATE testTable set testField='' WHERE
test_id in (100:1000);
> how about
>
> UPDATE testTable set testField='' WHERE
> test_id >= 100 and test_id <= 1000;
or just:
expr BET
how about
UPDATE testTable set testField='' WHERE
test_id >= 100 and test_id <= 1000;
Mike Doanh Tran wrote:
>
> Hi,
>
> How do i use the UPDATE statement to update a range of Primary Key id
> numbers. (let say 100 through 1000).
>
> Example,
>
> UPDATE testTable set testField='' WHE
Thanks Karel,
This worked almost out of the box, just needed to find out that 'len+1' has
to be replaced with the actual number and is not automatically set (like len
= length('CONSTANT%'). But the manual also explains this very well, I just
didn't think of substring.
Hannes
On 7/3/01 9:13 AM,
