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

writing my own sobel filter convolution - something is wrong
I am trying to keep it very simple, I cant see anything wrong with my logic, could anybody help poin

Is there a way to override built in php functions without APD?
I am trying to use the
rename_function()
override_function()
options that are built into

form submit at godaddy?
Trying to test form submission at GoDaddy and it does not seem to work. Here's the page...

h

admin with my register system?
Hey i wana make it so i can make a admin level on my register system , I'm kinda new to php to im no

mysqli_fetch_assoc returns multiple arrays, how to return a single array
Hello, I am using mysqli_fetch_assoc which is returning multiple rows, so it looks like:

Code

Problem related to Creation of PDF File?
Hi All,
I am facing a problem related to creation pdf file. when I am creating a pdf file of do

background color imagefill
Hello

I would like to ask you why I see this square in red color just in my local xampp insta

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

ctype() validation - allowing illegal characters
Hello,
I use ctype() to filter and validate a user form. However, I am trying to allow certain c

some query on multilingual website
Hi all,

Which is the simplest and easiest method to make a website multilingual,
is it put