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
Did you know?Explore Trending and Topic pages for more stories like this.
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' ....
No comments posted yet

Your Answer:

Login to answer
185 Like 7 Dislike
Previous forums Next forums
Other forums

Pulling out some result data from MYSQL
Hey Guys,

I've built a PHP page that has a for just imagine something like registration form

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

check comment for html
hi, I just wanted to check if a comment a user posts contains HTML, and if it does, to not allow it

array_combine() error
getting an "Warning: array_combine() [function.array-combine]: Both parameters should have an e

Displaying image pathname instead of image
Hello

Im trying to upload and then display images from a mysql database - Its only basic and

Get Total From While Loop
I'm trying to get the total for each product and add them for a Grand Total to list outside the loop

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

Problem in String replace program's output
Hi all,
I was trying to make a program which accepts a string and replaces it with another stri

Open link with largest int string first
I have the following links i would like to open either all at once or one-by-one. How would i procee

Php - mysql select?
hi, i have this code:

Code: <?php
session_start();
// dBase file
include &quo

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash