[RESOLVED] Error updateing multiple rows in phpmyadmin

Simplyput

Okay phpmyadmin is not my strong point but neither is php. Thus, I have to post this question. I am doing the following and can not understand why it will not work in phpmyadmin.


UPDATE dt_pro_rss SET cid='67' WHERE title='NY Giants'
UPDATE dt_pro_rss SET cid='67' WHERE title='Eagles'
UPDATE dt_pro_rss SET cid='67' WHERE title='Raiders'
UPDATE dt_pro_rss SET cid='67' WHERE title='Miami'
UPDATE dt_pro_rss SET cid='67' WHERE title='Denver'

The first one goes through then I get the error message below.

#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 'UPDATE dt_pro_rss SET cid='67' WHERE title='Eagles' UPDATE ' at line 2.

However, if use the above code one line at a time it runs?
What am I doing wrong? Any help will be greatly appreciative.

Thanks

Bonesnap

Try putting a semicolon after each line.

Simplyput

Thanks that did the trick.

laserlight

Note that you could have done this with a single SQL statement:

UPDATE dt_pro_rss SET cid='67' WHERE title IN ('NY Giants', 'Eagles', 'Raiders', 'Miami', 'Denver');

Simplyput

Hello Laserlight

You are right I could have updated it with one query if all the rows had the same cid but they did not only those I used as an example had the same ones. However, at the time I could have found all the similar cids and used one query on those, but my brain was fried at that point. 🙂 As I stated earlier I am not very good with mysql but I am getting there. Anyway it was easier for me to create the mysql strings with the data in excel copy and past it in PHPMYAdmin and hit run.