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

php/xmlrpc class issue
I am working on xml-rpc in php to start with.

I have a class that only has variables defined

First root of a number
Hi,

I can't find any function in php to give me the first root of a number.
Is there any

form problem
Hi all, I think this is going to be easy to resolve but for I have been looking at it to long and I

using a loop help
Hi guys , i need some help. I have this loop :
while ($row = mysql_fetch_assoc($Result)) { ?&

Filename and Line Number Custom Error
I have a class, with a method that accepts 2 parameters. I would like to output error messages.

generate seo frienly url from a text like wordpress
Convert: "åäö" to "aao", "space" to "-", "!?&q

Including calander to page - will not show other months than current??
im trying to add an existaing calander onto a profile page by using Code: <?php include "

Creating an invoice
Using fpdf I am trying to create an invoice to send to clients. The products are sold in pricing tie

php slowing my site?
Hi all,

I think that one of the reasons that my site doesn't work fast is that the code is ve

Not Inserting into DB
I can't get my Add new Division form to submit to the database. Anyone see my issue?

Code: &a