https://wiki.umiacs.umd.edu/adapt/index.php?action=history&feed=atom&title=SRB%3ASQLTricks 2026-04-07T12:19:20Z Revision history for this page on the wiki MediaWiki 1.43.7 https://wiki.umiacs.umd.edu/adapt/index.php?title=SRB:SQLTricks&diff=2190&oldid=prev 2008-09-16T17:41:56Z

<p></p> <p><b>New page</b></p><div><br /> * Add uid 102 all(999) access to files<br /> ** insert into mdas_ad_grp_accs select data_grp_id,102,999 from mcat.MDAS_TD_DATA_GRP t1 where t1.data_grp_id like &#039;0002.0009.0001.0001.0001.%%&#039;<br /> <br /> * Delete tickets to allow for collection deletion<br /> ** delete from mdas_au_tckt_grp where data_grp_id like &#039;0002.0009.0001.0001%%&#039;<br /> <br /> * delete all metadata where filename is 18*TIF<br /> ** delete from mdas_ad_mdata where data_id in (select data_id from mdas_ad_repl where data_name like &#039;18-%.TIF&#039;)</div>

Toaster