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
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 multiple logins for the same user code.
I want to simulate this via a "locked" column in a mysql table, but
would need the field to be cleared
I have checked Apache's log. There is no refused connection. And also with
MySQL I have set it to 999 connections and view the processes. Maximum
connection ever reached was only around 200. What I'm thinking now is. Is it
because of I use one time connection method? I mean every time the script
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
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 it failed
to update some rows. No errors return by the script.
Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 26, 2007 12:38 PM
> To: mysql@lists.mysql.com
> Subject: what's better query t
hi to all!
I have a table that contains ratings of suppleirs. almost 2000 records.
administrator uses a form with radio buttons (values R, A and NR) to
chanage rating for each supplier.
after he submit I have an array where index is $supp_id and value is
$new_rating.
Since, admin changes the rat
it with: AFTER some_other_column
Also sending this to the General list since it isn't a Windows specific
question. :-)
Matt
- Original Message -
From: "tooptoosh"
Sent: Wednesday, February 04, 2004 1:54 PM
Subject: mySQL autogenerate, update table
Hi all,
I have a mySQL table with
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 327772
able column will be start_date:
UPDATE table SET start_date = FROM_UNIXTIME(start);
Of course, this is all really quite unnecessary, since when you select the
data in some other part of your application, you can do the conversion at
that time. For example
SELECT FROM_UNIXTIME(start) FROM tab
Hello
I have a table that gets appended to every night with the LOAD DATA command.
The column 'start' is a unix timestamp. So when the LOAD DATA is done I then
want to update the Column to be human readable.
I was thinking of the following:
UPDATE table SET start = UNIX_TIMESTAMP(
>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, but a string one character larger is
Hi,
If i want to use "load data infile" into selected column, for example i have
5 column in one table and i only load data into column 1,2,4 and 5 and i use "load
data infile "abc.txt" replace into table test(t1,t2,t4,t5)" but after i load into the
table, the previous data in colum
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
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='' WHERE
test_id in (100:1000);
Thanks in advance for any comments,
Mike
--
MySQL General Mailing List
For list archives: http://lis
Probably this is what you want
http://www.webyog.com/forums/index.php?act=ST&f=5&t=351&s=7cd9c97584811d72b9305d3e691ab28f
Karam
--- Daniel Crompton <[EMAIL PROTECTED]>
wrote:
> Out of interest is there any advantage of using a
> primary key?, or is it
> perfectly ok/normal not to specify one?.
>
Out of interest is there any advantage of using a primary key?, or is it
perfectly ok/normal not to specify one?.
Im not quite sure what a primary does. I only used a primary key on one
table which had auto_increment column only because it forced me to add it.
??
> Hello
>
> I belive this is no
Hello
I belive this is not the correct place to ask the
question. You can try your discussion forums at
http://www.webyog.com/forums for SQLyog specific
questions.
Karam
--- William IT <[EMAIL PROTECTED]> wrote:
> Why SQLyog can not insert/update Table w/o Primary
> Key? Is ther
Why SQLyog can not insert/update Table w/o Primary Key? Is there additional setting to
enable this?
STIBS,
Thursday, October 17, 2002, 12:26:34 AM, you wrote:
S> I have a littlebig problem:
S> I want to UPDATE table1.fields with data from table2.fields WHERE the id (in this
S> case a product number) is the same in both tables.
S> OK, I did this:
S> UPDATE table1 SET table1.field1 = table2.fi
Thanx guys!
but:
I'm not in the mood to try Greg's suggestion ... LOL!
I think I'll work around that with Escapade programming language. It's much easier to
handle.
If not:
I run a script that checks record by record in the first table if an update in the
second table is available then I query
>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 16, 2002 5:15 PM
Subject: RE: Problem with UPDATE table ... can u help plz?
When I try that modified for my tables that fit this hypothetical, I get:
CREATE TABLE `sales_table` (
`item_s` varchar(100) default '',
`price_s
on the page shows a kluge
workaround.
Greg
-Original Message-
From: Bruce Lewis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 16, 2002 4:03 PM
To: STIBS; [EMAIL PROTECTED]
Subject: Re: Problem with UPDATE table ... can u help plz?
You need an InnerJoin to perform the operation similar
IL PROTECTED]>
Sent: Wednesday, October 16, 2002 4:26 PM
Subject: Problem with UPDATE table ... can u help plz?
Hi from Dresden, Germany!
I have a littlebig problem:
I want to UPDATE table1.fields with data from table2.fields WHERE the id (in
this
case a product number) is the same in both t
Hi from Dresden, Germany!
I have a littlebig problem:
I want to UPDATE table1.fields with data from table2.fields WHERE the id (in this
case a product number) is the same in both tables.
OK, I did this:
UPDATE table1 SET table1.field1 = table2.field1, table1.field2 = table2.field2,...
WHERE ta
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,
I want to update 160 records in a table. The field contains a variable value
and a constant prefex like
'constant: unique value for this record'
Is there such an UPDATE statement that would update this field into
'unique value for this record'
They way I would do it otherwise is using Perls re
28 matches
Mail list logo
