updating a single value to multiple non consecutive rows

Posted on 16th Feb 2014 07:03 pm by admin

I need to update the same value to multiple non consecutive rows. I need to add an experation date to about 6000 parcels.
I know I can update 1 with

SQL> update parcel
2 set expdate = sysdate
3 where prclid = 'A';

I imagin I need some thing like the following

SQL> update parcel
2 set expdate = sysdate
3 where prclid = 'A','C', 'D', 'G','E', 'J' ....

Your Answer:

Login to answer

Other forums

Perplexing problem showing a .jpg
Please disregard..........I figured it out

printing links
Hi every1

i am connecting to a table in sql and the looping through with a while ($ var = my

How do I use a global footer..?
If my index.php has a bole bunch of if functions and exit's in them

Dynamic memory problem
Hey,

At the beginning of my code, I have this line:

Shape* gShape = 0;

Else statement screws up all css
Does anyone know what goes wrong in the process with this php code?
This code seems to be causing

Cloud Computing?
Hello,

I was wondering if anyone could help explain this term to me. I'm starting to hear it

Parse Error Help
Hello, I got the parse error "Parse error: syntax error, unexpected ',' in register.php on line

PHP error on MySQL insert
I'm sure it's the simplest of issues, but I can't recall why this isn't working.

Code: [Selec

if description does not contain the following words
Hello everyone,

I am parsing a MS Excel (.xls) file and adding it's content to a mySQL databa

How to show a complete textarea ??
I enter Client Case Notes notes in a textarea field on a PHP form. The field is 5 rows deep and 70 c