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

Inserting into MySQL Newbie
Hi ive got a slight problem where ive made a simple web form where the customer inserts the ammount

start new row of pictures
on my site www.budstreasureauctions.com there is a featured auctions box that users will pay to get

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

TabControl Inside ListView Not Editing
Hello everybodyI have a ListView on my page. Inside the ListView I put a TabControl, cuz I want to p

Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.

I

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

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

batch file not building to webapps folder
Hello. I just started running Vista :P and can't seem to get my projects deployed. I found out how

I need to increse 6hours more, and i don't know how???
I need to increse 6hours more, and i don't know how???
<tr>
<t

InternetOpenUrl() Invalid cert
Hi all,

Does anyone know how to prevent calls to InternetOpenUrl() from failing with erro