eh. Should this be ... a perlfile ? pls give me the sorounding formatting.
no perlmonk me.
;)
Tarjei
> -----Original Message-----
> From: Emiliano [mailto:[EMAIL PROTECTED]]
> Sent: 4. mai 2001 20:57
> To: [EMAIL PROTECTED]
> Subject: RE: [midgard-user] Repliguard - the saga continues....
>
>
> Tarjei Huse wrote:
>
> > Is there a sql query I can use to find all id where
> sitegroup = 2 in my
> > midgard db?
> > i.e. _all_ the tables ??
>
> Not directly, but
>
> $ for t in article blobs element event eventmember file grp
> history host image member page pageelement pagelink person
> preference record_extension repligard snippet snippetdir
> style topic; do
> > echo "select id from $t where sitegroup=2;" | mysql -u
> midgard -pmidgard midgard
> > done
>
> will.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]