MySQL Forums
Forum List  »  Newbie

Simple update failure
Posted by: Richard Kurtz
Date: July 12, 2014 08:27PM

I am trying to update a mysql table.

UPDATE `rkurtz` SET `pic_desc`='Denver Botanic Gardens' WHERE `pic_num' >= '5268' && `pic_num` <= '5581'

When I run it I get:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pic_num` <= '5581'' at line 1

It's been awhile since I've done anything with MySQL so I've forgotten most of what I used to know (it seems).

I also tried

WHERE `pic_num' >= '5268' & `pic_num` <= '5581'
WHERE `pic_num' >= '5268' AND `pic_num` <= '5581'

with the sanme results.

All I'm trying to do is update the pic_desc field if the pic_num filed is between 5268 and 5581.

Options: ReplyQuote


Subject
Written By
Posted
Simple update failure
July 12, 2014 08:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.