By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,200 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,200 IT Pros & Developers. It's quick & easy.

Updating single row in table causing all rows in table to be updated with same update.

P: n/a
I have a table with ~2.2 million rows. Sometimes when I do an update
to one single row it will instead update ALL of the rows using the
same update. This happens every one in about 500,000 updates to a
single row.

I am running mysql 4.0.14 in WinXP. I am using PHP to do the update.

I am thinking something in the update itself is causing mysql to do
this. I don't have the exact SQL statement that causes the error
but I do have the data that is causing the problem. I am thinking
some character in the update is causing all the rows to be updated
when only one row is supposed to be updated. The single quote
character "'" is highly suspect.

Here is a sample SQL (cleaned up for easy reading): "UPDATE page SET
page_content = '$buf' WHERE page_id = $page_id"

'$buf' and '$page_id' are variables.

I am updated a column of a row of type "text" with the following data
set in '$buf' (Please excuse the fact that it's quite long):

"KLUC 98.5, Las Vegas' #1 Hit Music Station local weather KLUC
Privacy Policy Terms of Use Agreement Employment EEO Policy EEO Public
File Report As the school year just gets started, 98.5 KLUC, Las
Vegas' #1 Hit Music Station asks you this.. Are you ready to PARTY!!!
It's the return of the High School Elimination . It's your opportunity
to show your school spirit and try to survive from being voted off. If
you do, your school will win a free party at Gameworks, and you never
know what KLUC has up it's sleeves. Can VoTech repeat as champions or
will the rookies, Liberty or Shadow Ridge be the ones to take it all.
It's High School Elimination 2 from the only station with all the
school spirit, 98.5 KLUC, Las Vegas' #1 Hit Music Station. Click here
to register and vote! 98.5 KLUC, Las Vegas' #1 Hit Music Station is
bringing yet another huge KLUC concert to the Vegas Valley. Mack 10
live on-stage Thursday September 18 at the House Of Blues. Keep it
locked onto KLUC for you shot to win. It's Mack 10 brought to you by
Michelob, House Of Blues, and Las Vegas' #1 Hit Music Station, 98.5
KLUC. Every week the 98.5 KLUC High School Football Patrol pads up
with live updates from the best games of the week. Check out the
football patrol in the stands for the Bishop Gorman at Liberty and
Canyon View at Shadow Ridge matchups. High School Football Patrol only
from Las Vegas' #1 Hit Music Station, 98.5 KLUC. Every Monday -
Friday, KLUC midday man Tim Stevens plays all your favorite old school
music during the Old School Lunch Hour at noon. Call in with your
requests and you may win lunch for (2) from Aloha Kitchen. 98.5 KLUC,
Las Vegas' #1 Hit Music Station is teaming up with Aquafina to spot
you. Listen to KLUC to find out where the Party Patrol will be with
ice cold Aquafina and KLUC prizes throughout the valley. If you pick
an Aquafina bottle with an X on it, you'll have the chance to win
CD's, DVD's, PS2, Xbox, and Gamecube games, and tons of other prizes.
It's the Aquafina Get Spotted contest with Aquafina and Las Vegas' #1
Hit Music Station, 98.5 KLUC. Training with Trejo Listen to the
Morning Zoo M-F 5a-9a for a daily update on Trejo's progress! The 98.5
KLUC Party Patrol is back for the Summer of Jamz! Every Saturday
night, Rayne and the KLUC Party Patrol load up the Urban Suburban and
will broadcast LIVE fron your living room with awesome KLUC prizes
like movie tickets, CD's, concert tickets, Wet N Wild tickets, food
and drinks and more and they could crash your crib! BEST OF ALL, IT'S
FREE! Click here to fill out the entry form and get ready, because
Saturday night, the Party Patrol could be knockin' on your front door!
From Las Vegas' #1 Hit Music Station, 98.5 KLUC! upcoming events Tue.
September 9 11:00pm Tim Stevens @ Studio 54 Wed. September 10 11:00pm
JB @ Baby's Thu. September 11 11:00pm Bo Jaxon @ Club Rio kluc's top
8@8 Results From :: 9.8.2003 1. Suga Suga Baby Bash 2. Get Low Lil Jon
3. Can't Nobody Hold Us Down Christina/Lil Kim 4. PIMP(remix) 50Cent
5. Right Thurrr Chingy 6. Shake Yo Tailfeather Nelly, P-Diddy 7.
Thoing Thoing R.Kelly 8. The Way You Move Outkast morning zoo poll
The Bennifer (Ben Affleck & J-Lo) are to be married this weekend. How
long do you think this marriage will last? 1 year 3 years 5 years
Until J-Lo gets bored For Eternity current results earlier poll
results 288 people have taken this poll 2003 KLUC / Infinity Radio
Corp."
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.