NYCPHP Meetup

NYPHP.org

[nycphp-talk] Problem with MySQL UPDATE syntax

Tony Furnivall tonyf at buffnet.net
Fri Jan 11 10:39:46 EST 2008


Hi!

I'm having a problem with the UPDATE syntax for MySQL

(aside - I hate products that tell me I have a syntax problem, but 
don't tell me what it is - and then suggest that I go RTFM  which is 
equally uninformative:-()

I'm replacing the entire set of fields, WHERE a condition exists for 
some of the fields, ie

UPDATE table_name SET field1 = ' value1', field2 = ' value2', field3 
= ' value3, field4 = ' value4'  WHERE field1 = ' value1' AND field2 = 
' value2';

MySQL says that I have error 1064 'near WHERE field1 = ' value1' AND 
field2 = ' value2'

but it doesn't say what therror is (grrr!)

My questions:

My question is what is the appropriate way to expand the syntactic 
construct of "where_condition", which is not otherwise explained!

Help!

Tony


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.19.0/1218 - Release Date: 1/10/2008 1:32 PM





More information about the talk mailing list