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

Filename like the user name
I am creating a form and storing the values in file. Could anyone please tell me how to write a code

quick question
Hi ..

i have a question
how do i set a var so it displays via an echo
Code: $logo = '&a

Simpler method of getting variables from mysql
Hi Guys,

I'm trying to streamline my CMS's code and as I was writing a new page it occured to

Simple Question
I know this is a simple question, that if I knew what it was technically called i could probably loo

help with this code please?
Hello,

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

I am usi

C++ API to Oracle dB
I need to perform a select command to the Oracle dB to obtain information from a table.
What libr

Can't shake the "Warning: include()" error
I've just uploaded my site to a new server and where I have PHP include tags in my HTML, the browser

Values disappear from my array :( HELP!
hey all, I have a lil mysql/php/apache script that queries a database
and pulls put 5 integers.

PHP search multiple input field box help
I am having a problem with my search script. At current it will simply search by a selected date whi

parse error
On my local machine I keep getting parse error for my footer. When I put it online, it doesn't show