[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