d row is reported and the value is indeed only updated once.
Filed as http://bugs.mysql.com/8942
Regards, Jigal.
- Original Message -
From: "Jigal van Hemert" <[EMAIL PROTECTED]>
To:
Sent: Thursday, March 03, 2005 11:18 AM
Subject: Strange internal loop causing multiple updates
Tested on MySQL version 4.0.23, 4.1.8 and 4.1.10
OS: RedHat Fedora Core 2 / RedHat 8
Table type: InnoDB or MyISAM
Table structure:
CREATE TABLE `param_str` (
`id` int(11) NOT NULL default '0',
`name` varchar(32) NOT NULL default '',
`value` varchar(255) default NULL,
`match` varchar(255)
> That the thing see, the form(using GET instead of POST) sends data with
> the new dates like this:-
>
> id=1&name=Mark&job_number=AA1&job_date=2002-5-19
> &id=2&name=Mark&job_number=AA2&job_date=2002-5-21
> &id=3&name=Mark&job_number=AA3&job_date=2002-5-25
>
> and the UPDATE query like this:-
>
Mark,
Earlier joke rebounds - pardon me whilst I wipe the comedic egg from my
face...
> That the thing see, the form(using GET instead of POST) sends data
with
> the new dates like this:-
>
> id=1&name=Mark&job_number=AA1&job_date=2002-5-19
> &id=2&name=Mark&job_number=AA2&job_date=2002-5-21
> &
Mark,
Is it a two-fer-one sale today?
> I'm now trying to UPDATE the three records with one query.
>
> Once the data is INSERTED into the db with this -
>
> insert into mytable (id,name,job_number,job_date) values
> ('1','Mark','AA1','2002-04-15'),
> ('2','Mark','AA2','2002-04-16'),
> ('3','Mark
nal Message -----
> From: Mark Dale
> To: [EMAIL PROTECTED]
> Sent: Monday, April 15, 2002 6:33 AM
> Subject: Multiple updates
>
>
>
> I'm now trying to UPDATE the three records with one query.
>
> Once the data is INSERTED into the db with this -
>
I'm now trying to UPDATE the three records with one query.
Once the data is INSERTED into the db with this -
insert into mytable (id,name,job_number,job_date) values
('1','Mark','AA1','2002-04-15'),
('2','Mark','AA2','2002-04-16'),
('3','Mark','AA3','2002-04-17');
a form page is displayed wher
: Doing multiple updates
I have decided to implement the "soft-lock" schema below. I cannot use the
userID as the value for the lock. Is there any other unique number that can
be generated that I could use. I am thinking about using a session_ID in
PHP? Any suggestions/Comment
al Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 4:10 PM
To: Randy Johnson; [EMAIL PROTECTED]
Subject: RE: Doing multiple updates
Randy,
My recommendation (and there are probably many people who will disagree with
me) is to use a "soft-lock" sche
nson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 8:48 PM
To: [EMAIL PROTECTED]
Subject: Doing multiple updates
Hello,
I am creating a mock site that has a money balance that people can login
and pretend to pay money for stuff online via my site.
I am using php with mysql to im
use a soft lock
like you've described. I dunno.
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 9:10 PM
To: Randy Johnson; [EMAIL PROTECTED]
Subject: RE: Doing multiple updates
Randy,
My recommendation (and there are probably many
e for even
seeing the data and some (M$ SQL) used to lock whole tables to do a single
update. (sux big time)
HTH,
Cal
http://www.calevans.com
-Original Message-
From: Randy Johnson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 2:48 PM
To: [EMAIL PROTECTED]
Subject: Doing multip
t. The lock will not exist if it was never obtained by a call to
GET_LOCK() or if it already has been released.
Mark.
-Original Message-
From: Randy Johnson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 8:48 PM
To: [EMAIL PROTECTED]
Subject: Doing multiple updates
H
Hello,
I am creating a mock site that has a money balance that people can login
and pretend to pay money for stuff online via my site.
I am using php with mysql to implement this.
How do I make sure that a balance for a particular account is (locked) so
only 1 spend for that account can happen
14 matches
Mail list logo
