Run more than one select statement

Dev Shed Forums Sponsor:

October 4th, 2012, 08:47 AM

timhersh

Registered User

Join Date: Oct 2012

Posts: 1

Time spent in forums: 14 m 48 sec
Reputation Power: 0

Run more than one select statement

Hello,

I am somewhat familiar with SQL. I have a website in which I need to update some rows (2000 of them) with different values. I have all the code ready, I had to break apart a excel database and came up with this code. I have searched everywhere and can't figure out to get this to work. When I run the code below I get this error

MySQL returned an empty result set (i.e. zero rows).

Any help would be great

UPDATE `zen_products` SET `products_price`='99.98' WHERE `products_id` = 866080;
UPDATE `zen_products` SET `products_price`='99.98' WHERE `products_id` = 866092;
UPDATE `zen_products` SET `products_price`='99.98' WHERE `products_id` = 866117;
UPDATE `zen_products` SET `products_price`='99.98' WHERE `products_id` = 866131;
UPDATE `zen_products` SET `products_price`='99.98' WHERE `products_id` = 866155;
UPDATE `zen_products` SET `products_price`='114.98' WHERE `products_id` = 866166;
UPDATE `zen_products` SET `products_price`='114.98' WHERE `products_id` = 866167;
UPDATE `zen_products` SET `products_price`='114.98' WHERE `products_id` = 866179;

October 4th, 2012, 12:02 PM

cafelatte

Contributing User

Dev Shed Intermediate (1500 - 1999 posts)

Join Date: Mar 2008

Posts: 1,923

Time spent in forums: 1 Month 5 Days 16 h 21 m 8 sec
Reputation Power: 377

Code:

Works for me...

DROP TABLE IF EXISTS z_products;

CREATE TABLE z_products (products_id INT NOT NULL PRIMARY KEY,products_price DECIMAL(5,2));

INSERT INTO z_products (products_id) VALUES
(866080),
(866092),
(866117),
(866131),
(866155),
(866166),
(866167),
(866179);

UPDATE `z_products` SET products_price = 99.98 WHERE products_id IN (866080,866092,866117,866131,866155); 
UPDATE `z_products` SET products_price = 114.98 WHERE products_id IN (866166,866167,866179);

SELECT * FROM z_products;
+-------------+----------------+
| products_id | products_price |
+-------------+----------------+
|      866080 |          99.98 |
|      866092 |          99.98 |
|      866117 |          99.98 |
|      866131 |          99.98 |
|      866155 |          99.98 |
|      866166 |         114.98 |
|      866167 |         114.98 |
|      866179 |         114.98 |
+-------------+----------------+

October 4th, 2012, 12:38 PM

r937

SQL Consultant

Join Date: Feb 2003

Location: Toronto Canada

Posts: 26,380

Time spent in forums: 3 Months 1 Week 2 Days 7 h 54 m 8 sec
Reputation Power: 4140

Quote:

Originally Posted by timhersh

MySQL returned an empty result set (i.e. zero rows).

updates don't actually return any rows

think about it

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book

Viewing: Dev Shed Forums > Databases > MySQL Help > Run more than one select statement

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump