Re: SQL select and update command
2001-10-10 16:37:09
Subject: |
Re: SQL select and update command |
From: |
Mark Stapleton <stapleto AT BERBEE DOT COM> |
Date: |
Wed, 10 Oct 2001 16:35:19 -0400 |
On Tue, 2 Oct 2001 11:06:31 -0400, it was written:
>Could someone give me an example how to do a select and then run command
>against the select reqult? For example, I want:
>
>Select volume_name from volumes where access!='READWRITE'
>then
>update volume the_result_from_select access=readwrite.
Easy.
upd vol * stg=<storage_pool_name> access=readwrite
--
Mark Stapleton (stapleton AT berbee DOT com)
Mark Stapleton (stapleton AT berbee DOT com)
|
|
|