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
Did you know?Explore Trending and Topic pages for more stories like this.
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' ....
No comments posted yet

Your Answer:

Login to answer
185 Like 7 Dislike
Previous forums Next forums
Other forums

Comparing MySql data and arrays.
I have a mysql table set up like this:
idsubjectbodyuseriddatetimetags1blog subjectblog body111|2

Database connection failure
Hello All,

I am trying to create new connection to Oracle DB 10.1,
I could not see a

Must be a string? Huh, what? HELP?
with the following script, I get
Fatal error: Property name must be a string in /home/content/e/

PHP code needed to get/post form fields and request mysql query results.
I'm new to PHP

I've created an html form to allow the user to request a basic telephone dire

Saving data from a form into a file
Hey everybody,

Sorry, I am really new to PHP coding and such but a project kind of got thrust

ALV sum various columns problem
Hi all,
I'm doing a report on ABAP for a timesheet of the current month. The output i want is s

Please help understand this code
I noticed the index page on my site was modified this morning and found this code inserted at the bo

Why does first ever HttpSendRequest take longer?
I promise this isn't as simple as it sounds. I'm wondering why the the first ever call to HttpSendRe

Ignore html and bbcode?
I've created a function to limit the amount of text according to the amount of words.

However

Trouble with a select list
Hello All!
I was wondering if any of you guys could help me with a small problem I'm having!

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash