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

Tree Menu
Hi guys,

Can anyone help me making a tree navigation system? I have a site where I'm allowin

i need help with php header and footer
I have designed a header and footer for my site and they seem to be ok when they are running individ

Creating web pages by php
Hello again,
I was just wondering us there a way to use a php script to create a new web page. I

Fetching META TAGS through
Hello everybody
I want to fetch meta tags of a domain.
It will be done from following code of

help with this code please?
Hello,

I am trying to build a remote upload script for my image hosting site.

I am usi

Transferring session variables into MySQL
I am trying to transfer $_SESSION variables into MySQL. However there is an error in my MySQL statem

Sub-domains & calling unique content
Hello,

Is there a way use something similar to the $_GET function for a sub-domain? I to be a

Security Exception on pages using AJAX
I am getting the exception: attempted to perform an operation not allowed by the security policy on

Multiple Do / While Statements?
I'm still very new to PHP, and running in to a problem when trying to execute a do/while loop inside

delete comma
HI,

How to delete "," at the end of the string.
Code: $match = 2009/02/03/a2corr